DSXchange

Hi, while Running the Job I am encountering the following error. The Job generates xml files from several input files.I need to add some exception files also when the perticular condition fails. After I added the Exception files by placing the reject links in Look ups-- I got the following ERROR Is ...

Hi ,

I am a new bee to Datastage.

I need to generate a zipfile with all the outputfiles genetated thru multiple jobs .Is there any stage in DataStage which serves this purpose.
Please suggest on this

Thanks

Hi Naveen

Thanks a lot for quick response,i am developing in parellel jobs.
hash file is not availble in parelle stages.i suppose.

can you explain me how to achieve in parellel jobs.

regards,
vinaya

Hi All, I need to join 2 tables based on one key coloumn. I need to populate a value for a perticular coloumn based on matched records i.e one type of value for matched records and different value for unmatched records. ex:If the records in two tables satisfy the join condition then for matched reco...

Hi all,

i am new bie to datastage,can any one helpme me to change the date format.

source column is like:

Fri Jan 20 16:59:51 EST 2006

but i want output as like:

YYYY-MM-DD T 00:00:00 (format)

how can perform this,can any one help me with exact syntax

thanx in advance

Diya

Hi all,

i am new bie to datastage,can any one helpme me to change the date format.

source column is like:

[b]Fri Jan 20 16:59:51 EST 2006 [/b]

but i want output as like:

[b]YYYY-MM-DD T 00:00:00 (format) [/b]

how can perform this,can any one help me with exact syntax

thanx in advance

Diya

Hi all, We are converting CSV files(Input) to XML files(Output). Input file format: Empno, Ename, Job 1,X,A 2,Y,B 3,Z,C Required Output file: <ApplicationPrincipalAttributeValues> <AppAttributeName>Empno</AppAttributeName> <AppAttributeValue>1</AppAttributeValue> </ApplicationPrincipalAttributeValue...