DSXchange

Hi I have used Field(DSLink4.col1,"/",1,Count(DSLink4.col1,"/")), iam gettting the following warning DataStage Job 97 Phantom 9010 Program "JOB.1124520702.DT.1386333214.TRANS2": Line 43, Improper data type. Attempting to Cleanup after ABORT raised in stage test1..CTrans...

we are looking to load URL data from files, but should not load any detail information held in the final part of the URL (e.g. personal information, chat messages in the URL parameters). Effectively what we need to do is load the URL string up to (and including) the final / in the url - this should ...

Hi

according to me when you restart a sequence it will start from the top, there are options in the sequencer, where you can give condition for restartabilty. This can be seen in the job properties tab page of the sequencer.

regards

Magesh S

Hi We are having a job, where a oracle stage, transformer and sequential stage are used. But we are just selecting 0 from dual and writing to a file. In the after job sub-routine we are calling sql loader to load the data from dat file to table. The number of data will be in the range of 20Million. ...

I want to write a routine, which needs to call a oracle database procedure and return the error or success code. Based on that the job should get failed or success. i have thought of ODBC stage, but we need to create ODBC datasource in the client for the stage to connect. But since iam not sure how ...

i have experienced this type of error on ds 5.2 server version using oracle database. the solution done was stopping the ds engine and starting the dsengine again, the problem got solved, may be you can ask some expert to stop the dsengine and start after 10 to 15 min

magesh S

Ok thank you

There is a hierarchy of sequencers of which the main sequence call the subsequent sequences. Main Sequence Sequence 1 Sequence 2 Job 11 Job 12 Job 13 Job 21 Job 22 Job 23 Job 24 In the above scenario, when running the "Main Sequence", if the "Job 23" fails or aborts then when re-...