DSXchange

Ray ,
Can you please tell me where this information is present in the sever?
I mean which path ?

And how to retrieve this?

Since dsjob -lstages will be accessing some data which is present in the unix server ..

Any help will be appreciated greatly..

I added a second transformer . It is showing the transformer but not the oracle stages .....

Yes , I am able to see the transformer..

The job is running fine . Issue is when I fire the dsjob lstages project jobaname command in unix it is not providing the stage names ..

I have four stages . Source is Oracle stage.From oracle stage we are loading the data into a hash file and from there via transformer into target table which is again a oracle table . But when I fire this command it is not providing the source oracle info . And for hash file it is giving with "...

Hi All ,
I want to know how we can get the stage names via unix commands .
I tried dsjob -lstages <project> <JobName>
But it is not providing exact info .
For eg it is not providing the oracle stage info .

Is there any other way to identify the same ?

Hi All , Could you please help me in the below req. We are receiving 1 file from our source and this file needs to be loaded into the table . But the source system is sending a fixed length file of 1000 bytes or 3000 bytes . Can datastage server job handle this dynamically . For eg: Today they may s...

Hi All , I am getting the below error message while trying to view data from ODBC connector . Failed to open native library : /opt/local/Information Server8.5/ASBNode/lib/cpp/libfcl.so:ld.so.1:java:fatal:libicuio.so32:open failed :No such file or directory Please let me know what may be the reason w...

It is easily possible to do this with Ereplace() if that's the only occurrence of 301 in the data, otherwise you'd have to do some more manipulation to determine which occurrence of 301 to replace. R ... Hi Ray, Could you please let me know how to use with Ereplace since there will be multiple occu...

Hi ,
I have a requirement for replacing a substr strting from 10th to 13th.
Ex:
Ad12345678301ATI

I need to replace the value starting from 10th position to 13th
In the above case 301 with 812.
please help .
Is it possible to do this with Ereplace .

I am getting the data in a seq file in the following format .
2008-12-09 00:00:00
While inserting into oracle table I am getting warning .
Should I perform a oconv on this data ?
Please advice

Hi, Could you please help me out in the below questions. 1) If we have a file with combined row-delimiter (which means a char is appended in front of the new line char), is it possible to set the combined delimiter as the row delimiter in data stage? Field1|Field2|Field3${LR} Field1|Field2|Field3${L...

Hi craig,
The automatically handle option is enabled ,but still its not aborting .

Hi,
I have a seq which is calling 30 jobs .If one is failing the seq should abort , but I am facing a situation were if any of the jobs are failing the seq is not aborting . Can any one help me how to fix this .

Hi ,
I have a req where I need to select only the first record from a oracle table via Datastage job .Could any one tell me how to select only the first rec.