DSXchange

Yes that is true. One scenario to share with you - When I imported my DS jobs with executables to my pre-prod environment, some of them failed due to the common routines which were not separately compiled there. Either I had to compile the routine once, or compile the job that is using that routine....

Thanks Craig.

Should I go forward with the way as anticipated by me .. for fixing the array size ? If any of you have any authoratitive answer pls do let me know.

Thanks a lot in advance.

D Paul

Hi Badhri, I am also trying to figure out the exact usability of the Array size property. What I feel till now is that we should calculate the no of bytes for a row and by seeing the network bandwidth between Oracle server and the Datastage server, try to reach to one numerical figure which will be ...

I am getting this error while running my DS job. The data is loaded successfully but this warning is coming up just before the last statement, in the log. Pls help to remove this warning. "DataStage Job 9 Phantom 2168 Program "JOB.660314562.DT.1248969383.TRANS1": Line 172, Variable &q...

Can u pls tell me which function u r using in the transformer ? Thanks.

D Paul

I see that a TO_DATE function is called like (TO_DATE(:1, 'YYYY-MM-DD HH24:MI:SS'). So in the transformer I have given a hard coded value (just to test) like '1999-01-01 23:20:20' but then when I run, I get the following error: ORA-01830: date format picture ends before converting entire input strin...

After searching thru the site, I saw a lot of query regarding this, but could not find a suitable answer. I do not have the PDF documentation to refer to, as sugested by some members. Here is my problem.. (DS 5.2) My input is OCI8 stage and the column is CHAR(26) field having a value of say, 1998-08...