DSXchange

When I am trying to run it again, it is giving error.

$ $DSHOME/bin/dsjob -run -mode NORMAL bhidev facility_fact
Error running job

Status code = -2 DSJE_BADSTATE
thusmiannadv21: /home/bhi


Thanks
Kavuri

Sorry Craig,

I found the job successful, but I am not getting the target file generating. But when I run job from director I got the outout.

Even I am not getting any errors.

$ $DSHOME/bin/dsjob -run -mode NORMAL bhidev facility_fact

Status code = 0
thusmiannadv21: /home/bhi


Thanks
Kavuri

Hi Craig, I tried but in vain. I am getting error. May be something needed to modified in dsenv file. Can you figure out what should be modified. $ cd `cat/.dshome` ksh: cat/.dshome: not found. thusmiannadv21: /home/bhi $ cd `cat /.dshome` thusmiannadv21: /medstat/advantage/common/Ascential/DataStag...

Hi Craig, I tried it. $ cd `cat /.dshome` thusmiannadv21: /medstat/advantage/common/Ascential/DataStage/DSEngine $ . ./dsenv thusmiannadv21: /medstat/advantage/common/Ascential/DataStage/DSEngine $ dsjob -run -mode NORMAL bhidev facility_fact ksh: dsjob: not found. thusmiannadv21: /medstat/advantage...

I tried as you told but I am getting following error. $ dsjob -run -mode NORMAL bhidev facility_fact exec(): 0509-036 Cannot load program dsjob because of the following errors: 0509-150 Dependent module libvmdsapi.so could not be loaded. 0509-022 Cannot load module libvmdsapi.so. 0509-026 System err...

Hi,
I am trying to run my jobs in command prompt. But I am unable to do so I am getting following error.

$ dsjob -run -mode NORMAL bhidev facility_fact
ksh: dsjob: not found.
thusmiannadv21: /home/bhi

Please tell me what changes ( like PATH or LIBPATH) I have to make ?

Thanks
Kavuri

I am worrying, in production there might be some command may be needed for compiling. So I am asking about this. Can you tell me what kduke is interpreting in the link what you have provided? Is this where on the server in the DSEngine directory we can compile? Narasimha can you tell me how to reset...

Hi, Can any body tell me how to compile a job from command prompt?

Thanks
Kavuri

Thanks Ray

I am extracting from a db2 database. i haven't made any modifications but DataStage is giving double quotes around date fields in output csv files.

I need to eliminate them.

Thanks
Bhargava

Hi,
I am having some of the fields Varchar and date fields are enclosed by double quotes in my terget csv files. I want to eliminate them. How can I do this?

Thanks
Kavuri

Eventhough my field is defined with char of length 13, incoming data is of variable length. So If we want to eliminate this warning what can I do? I cant change the width of the field.

Thanks
Kavuri

Hi, Target flat files are utilised by another product which is written in Orchestrate. So i am writing them in .csv format. If you have any other idea please let me know. Or please tell me how can I achieve this? If not 20,000 we will prepare more flat files. That is what the requirement from the te...

Hi, I am having a big DB2 table in terms of number of rows. After passing through various stages I need to write into a flat file, so I am writing into a .csv file. Now as the number of records are very large in terms of billions, I want to store the result into multiple files with same name with la...

Can anybody tell me what is the warning here Sequential_File_2: When checking operator: When validating export schema: At field "ROLLNO": "null_field" length (0) must match field's fixed width (12) Sequential_File_2: When checking operator: When validating export schema: At field...