DSXchange

If its a single value then yes, but if its a row then you will need to redirect it to an output file and read that in datastage. If its just one value then you can go with narasimha's suggestion.

Use the before job subroutine "Execsh" to fire your script. Redirect your output to a file and then read that file in your datastage job. Make sure you adhere to the strict rules of meta data for the sequential file to read your output file without any fuss.

I just tested it. It works. Just like magic

In the query there is order by three fields (ie order by 1,3,4) and i used sort stage to satisfy that , but the data is not sorting . any clue why this is happening? any other solution to sort apart from this? Click on the blue part to go to beaditya's relating post. How are you exaclty specifying ...

What format is your date in. Date() gives internal format (number of days since Dec 31, 1967). You need to do your comparison by changing your date into internal format. SOmething like Date() < ICONV(A.REDEPLOY_EFF_DATE,"<CONVERSION CODE>") AND Date() > ICONV(A....

Well Yes and No. You will have to run that stored proc./utility and capture the output and read it. I am not exactly sure how its done in Oracle. I have heard that oracle uses some stored procs. do get this done. So you are looking at STP stage and outstreaming it to a file. I know in sql server 200...

kcbland wrote:You're in for difficult times.

You can say that again, and louder

How was it encrypted? Is it using Oracle stored procedures or other utilities. It need to be decrypted the same way for you to read it. You need to find out how it was encrypted.

Use the filter command and use the sed operation to find and delete empty lines.
Put this in the filter command box

Matches. Use the matches command. Basically your constraint will look like DSLink5.CONTRACT_TYPE matches '...PMO...A...') On second thought, never tried that, i know for sure that '...PMO...' works but dont know if something like '...PMO...A...' will work. Give it a shot and let us know. As per your...

Do an exact search on "ORA-03113". That should get you started. Also search for the same in google.

Indeed. This site has helped thousands and will continue to do for many more. You can get access to premium content for a little over a quarter a day. If your from brazil that will be a little over half a brazillian real

Wow, did you get your answer already. Stick to one platform throughout. Either windows or unix. Search this forum for which one to use and which one not to. Parallel process and Node configuration wont be a challenge. But cant say about migration. Plus if a single platform is adhered to, it becomes ...

Try running 10 instances first and see how they behave. As Ray noted, some jobs might refuse to start as no resources might be present. Also you need to take into accord other activities happening on your server.
Use the sequence job to run your jobs in parallel.

As Kim suggested, do your select and load it into a hashed file with a dummy key. Then read that value where ever you want, in the transformer or set it as a default value of a parameter etc.