DSXchange

Yup, Chulett and Istsaur said was right, I am not trying to compare code between environemnts, current environment is not GRID enabled. Current environment is, we have enough memory space for V8 which doesn't have grid. we have 2 node configuration, space dedicated for datastage is around 450gb, so,...

old versions was not in current project, where I used grid. Current project is websphere V8 and we don't have Grid setup. performnace is not good, even for staright map, it's taking lot of time like for 4 millins it's taking 20mins so, is there any other way, I can change some settings, which will i...

Hi, We are using now websphere data stage v8, I could see very low performace with compare to Datastage 7.5.1A and 7.5.x series, but the difference is earlier we do have grid environment but now with datastage 8 so, will it really causing the probelm. even for straight load it self , is not same as ...

How can I auto purge off only for specific job, can you please suggest me

nope , InvocationId is different for each call.

but still it's throughing the same error

Hi Mike-- Could you please share the details if you hear anything form IBM technical support.

Hi, I have some sequences which is calling couple of multiple instance jobs along with regular Load jobs, so when I try to call those sequences in one master sequence then I am facing problem called status 99. " NW_ONE_EPM_SEQ_Recon_Daily_Balance..JobControl (DSWaitForJob): Job NW_ONE_Truncate_...

Hi, I am trying to ocnvert 6 digit value like 'yymmdd' value into actual date format like 'yyyy-mm-dd', I am able to do it by using below function but it's throowing below warning, Can anyone help me to stop that warning. function : StringToDate(GLTxnread.NW_WRK_DT_SRC_ORIG,"%yy%mm%dd") Wa...

Thanks for your help.
space is not there for string columns it's there only for numeric columns.
yeah it's place holder. Is there any way we can read the same data/file with numeric data type only? not with char?

I tried giving field delimiter as none and removing that property but I can't fixed with file, still there is one space between fields.

Hi,
I am trying to create fixed width file with Numeric data type but one space is coming between for all columns.
Is there any way we can generate file width fixed format with numeric data type without space between columns.

*Note - Title made more descriptive - Content Editor*

If possible please post into forum so that all take it as reference.

Why don't you, put all the data into send that file as attachemnt, which is easy to verify rejections, even if you send zip file still they need to open 95 files to check rejected records which are related to same kind of data.

your question is not clear to me. But if you are expecting to update effective date column with value from Source and it's not doing, even you are doing direct mapping. then, try with 2 records u can easily understand where it's going wrong, it might be because of Default values specified for that c...

Hi,
Try find how many number of records are there in the file from unix box with unix commands or in some other way, insted of depend only on DS link counts.

unix: wc -l <filename>

yeah, you can use sequential file stage, just need to take care about file properties as fixed width file properties.