DSXchange

Hi ,

If your requirement is to handle just a fixed width string "000000000000000000000000000"
then just add a simple if INPUT_VALUE="000000000000000000000000000" then 0 else INPUT_VALUE

Hi There, I have four jobs in a sequence and when I run the sequence all the jobs with in ran successfully but the sequence failed with the error shown below. Job control process (pid 13007) has failed From previous run DataStage Job 202 Phantom 13007 Abnormal termination of DataStage. Fault type i...

Hi, In my project the source is Oracle and target is also oracle. For some of the transformations like concatenations, substring functions are written in Oracle( in SQL) rather than doing in DS transformer. My point is that doing the smae in DS will yield good performance since DS uses parallelism c...

I am trying a run a job which was working fine all these while. Suddenly I am getting a weird error-> wrapDescribeOperator() error while running DS - fatal error .... ... ... main_program: Internal Error: (status == APT_StatusOk): sc\sc.C: 3824 Fatal..error Again if i compile and run it works fine.....

My customer is interested in selecting right RDMBS environment to run DS EE to solve a multi field and relational database datamerge. The customer realiozes the value of running in parallel and which will match internal data partitioning of a given RDBMS. Which stage can be suggested...!!

Thanks a lot

Hi,

I want to understand why parameter sets are used. I belive they are used to set environment variables for jobs. I read that version 8 has many modifications in parameter set!! can any one discuss abt this

How to we import SAP data into EXCEl sheet. In my job the source sap data needs to be taken into excel sheet. If i try exporting i am getting formatting errors. Eg. I have 000.20031 -> is coming as 0.20031 since we cant convert the format as text when we try to export data, i am wondering how do i p...

For performance stats- > APT_DUMP_SCORE
To Collect the Audit Stats of the JOB -> $APT_RECORD_COUNTS

Hi I want to know the use of DSSetUserStatus function. Is it talking abt the status of job like -> abort, running, success or is it something else. In my job it is used as a Transform, that means we are calling it for every record in the table. How does it reads the status of records?? SETUSERSTATUS...

Hi I want to know the use of DSSetUserStatus function. Is it talking abt the status of job like -> abort, running, success or is it something else. In my job it is used as a Transform, that means we are calling it for every record in the table. How does it reads the status of records?? SETUSERSTATUS...

what the difference between using ODBC and oracle stage. What are the factors that needs to be considered to choose it?

Hi..
My job is aborting because of the following reasons..

Contents of phantom output file
DataStage Job 76 Phantom 14128
writeSocket() returned 4
DataStage Phantom Finished.

Can any one say why this has happened????/

I have a question.. I just want to know how this function works internally.. say I have a string 20030707 StringtoTimestamp converts the given string into time. %yyyy%dd%mm says let the first four characters be year. Next two be date and next two be month isnt?? If i dont specify the format what hap...

Hi.. This is a bit tricky question.. 1 Actually a sequential file can read in ONLY ONE NODE.. Yes i do agree we have an option that says whether we can ask Datastage to keep partitions or not... This comes into picture only when we read multiple files using a sequential file. For eg. i have 3 files ...