SAS Data Integration Studio, DataFlux Data Management Studio, SAS/ACCESS, SAS Data Loader for Hadoop and others

How do I read and load a .JPG file to Oracle table:

Reply
Contributor
Posts: 38

How do I read and load a .JPG file to Oracle table:

I want to migrate an Oracle PL/SQL job to SAS DI. The Oracle Job does the following:

1. Read the files.
2. Parse the name for an ID value.
3. Read an XML file with ID value.
4. Insert into a table the ID and the OS file.

I am looking for a method (may be a generated transformation) to read the file and its name into a placeholder for further processing and pass those values to a TABLE_LOADER transformation.

I am not a SAS programming guru and will appreciate some extra details.
Respected Advisor
Posts: 3,908

Re: How do I read and load a .JPG file to Oracle table:

Hi

If you have already a perfectly working Oracle PL/SQL job then why trying to rebuild everything in SAS DI and not only implement some code in DIS which controls execution of the PL/SQL component.

If this would be a way to go then the following paper will be interesting for you: http://www2.sas.com/proceedings/sugi30/063-30.pdf

HTH
Patrick
Ask a Question
Discussion stats
  • 1 reply
  • 348 views
  • 0 likes
  • 2 in conversation