DSXchange

Hi All, I am trying to handle the rejects from the Db2 API Stage My job design is : Sequential File --> Transformer --> Db2API I want to capture the rejects out of API Stage I tried to put a reject at transformer , but the rejected information is not passing through that link I have kept the array s...

Hi All, We got this working by selecting the Flatten Arrays while selecting the columns. We are getting source files from the Packed Decimal (Comp 3) and EBCDIC format But when we select the character set as EBCDIC, we are not able to view the data, but we can view the data (Partially-some columns) ...

Hi Mike,

We selected the option of As-Is while importing

Should we make changes to this option.

As per the design we have to get rid of these duplicates before processing

Please advise

Many thanks for your support

Regards

Hi Mike,

Please let me know where can i set the array size

Regards

Hi There, We are using a CFF stage to read one of our input file We are able to view the all columns properly but when we view it in datastage each record is shown as 4 times If i have 2 records in the input file, it shows 8 records when i view the data from Datastage, when i tried to load the file ...

Hi Ray, Please see the below code ErrorCode = 0 ; * set this to non-zero to stop the stage/job $INCLUDE DSINCLUDE JOBCONTROL.H $IFNDEF JOBCONTROL.H $INCLUDE DSINCLUDE JOBCONTROL.H $INCLUDE UNIVERSE.INCLUDE ODBC.H $ENDIF *---- Start processing strOutPath = DSGetParamInfo(DSJ.ME, "RP", DSJ.P...

Hi, I am having a very resilient SIGBUS issue. I have searched the forum (for 'SIGBUS') and found little that helped. My issue is with the stored proc stage and using it to connect to Sybase IQ 12.7 on another machine to trigger off an SP that runs xp_cmdshell within IQ to trigger off a command line...

Hi there I have a decimal field of (19,4) being extracted from a datasource and I'm trying to load it into the warehouse as a NUMERIC(18,2) datatype. When I run the job, I get the abovementioned error. After much wrestling, I then just changed the datatype in the warehouse to DECIMAL(19,4) to match ...

Has anyone configured Metadata Workbench to work through Cognos? By this I mean if you've got a Cognos report where the source of the report has been populated by Datastage and you can view the linage inside of MW and, this is where my problem comes in, you right click on a field in the report and c...

Thanks for all the suggestions!

Sorry that I am only replying now, I wrote my DS 8 certification exam today and I passed!

I'll play around with the suggestions and see which works best.

Cheers

Hi Guys, I've got a interesting requirement. I've got a 60Gb delimited text file. Based on the value in one of the columns I needs to split the big file into multiple smaller files. I could do this in a transformer with a constraint, but unfortunately the values used to split are only known at run-t...

Hi

I'm trying to convert an integer value to a string or char value.

ex var = 1 (integer) and I want to convert it to a string or char "1", the reason for this is because I then want to reformat it to "01".(Add the 0)

Thanks!

Hi, Thanks for the reply. I did the ascii function and the "white space" returned "0" which is NULL. I checked the job that creates the data set and it had one place where the column was defined as char and not varchar. Changing it to varchar fixed the problem!!! :D Thankyou very...

I guess this is still a workaround, but it works!!! Take the "-o" option out of $APT_COMPILEOPT. This effectively disables the compiler optimization. Manually add "$OSH_BUILDOP_NO_OPTIMIZE = 1" to the enviromental variables for the problem jobs. The job now compiles within 2 minu...

Hi,

IBM was able to reproduce the slow compile time on various platforms.
They are working on a fix.

I'll keep you posted on the resolution.

Cheers
:D