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

[Halaku]

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.

[Patrick]

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