DSXchange

Hi,

I have a Orace stored procedure which stores the output results to cursor. So is it possible to retreive the o/p records using Stored procedure stage.

Thanks.

Hi, We have called DSSetUserStatus in our routine to set the user status. After some patch applied in the server, we are facing some issue with this routine. The job abort with phantom error. Could you please help. Thanks. Error: DataStage Job 415 Phantom 31847 DataStage Job 415 Phantom 31847 DataSt...

Hi,

Can anyone please let know the use of "Incomplete column" option in sequential file stage with example?

Thank you!

Hi,

Is there any limit in size or (max size) while generationg xml file using XML output stage?

The target datatype is S999 COMP-3. I need to move spaces to this field

Hi,

Is it possible to populated spaces to COMP-3 field? Thanks

Can any one suggest me, what action need to take for the below mentioned error. DataStage Job 69 Phantom 10048 Date/time stamp in file header has been modified! Program "JOB.1431251657.DT.1518055563.TRANS2": Line 681, Unable to reopen file unit. Date/time stamp in file header has been modi...

Hi,

Can anyone help to convert numeric value to mainframe COMP field.

The target datatype is S9(4) COMP.

It would be great if anyone could share the logic to implement this in datastage routine.


Thanks!

Server is unix

Hi,

Im running the below command where the DataStage has installed.

dsjob -run <project name> <job name>.

I am getting the error message Like: dsjob: not found

Can any one help me to resolve this issue?

Hi,

The target datatype is varchar. Am I using the fmt function correctly?

Yes

Hi, I need to format my input value based on the length of the target column. So the length in the 2nd argument of Fmt function should be a variable. I assign below value to one of the stage variable. StageVar1 = '"':StageVar:"'0'R" : '"' The StageVar is holding the varaible leng...

Thanks for your answer....

Will the job get hanged if I use 35 i/p and 35 o/ps?. Pls give me the max no of connection (i/p & o/p) that is possible per transformer.