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

Halaku — Wed, 22 Jun 2011 19:53:15 GMT

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.

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

Patrick — Thu, 23 Jun 2011 00:55:09 GMT

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

topic Re: How do I read and load a .JPG file to Oracle table: in SAS Data Management

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

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