DSXchange

Hello Guys, I am working with complex flat file stages to read the EBCDIC files. My intitial requirement was to convert this EBCDIC file to ASCII file to reach this i was reading the src data from CFF stage and directly mapping to Sequential file stage.Till this point it is working good. Now my prob...

Yes i even tried out with the prefix (') quote charector. Its is working fine, But the i have one more concern here. If some system process the same excel file what i generated will the value of the filed will have quote? Like if they trying to load the same file in to a Database then that particula...

Hi Thanks for ur sugession. Yes even i do agree with your comments. Its not a datastage issue but the cell properties of .xls file are always taken as general by default. When the generate the file the defaulf cell prperties are General, So could you please help me is there any way can we change the...

Hi Craig,

the excel file is .xls.
The leading zeros are stripped off after witting in to xls file.

Thanks

Hi,

I am trying to generate excel file in data stage.
In doing so i have a problem, When i am trying to append leading Zeros to a filed and witting into excel file all the leading zeros are stripped off.

Can some one help ma in solving this.

Thanks in advance.

Hi,

I am trying to generate excel file in data stage.
In doing so i have a problem, When i am trying to append leading Zeros to a filed and witting into excel file all the leading zeros are stripped off.

Can some one help ma in solving this.

Thanks in advance.

Hi

I am new to datastage concepts i want to know about the background process in the server for datastage

How can we change the datatype of column of a datastage job in unix?
Where exactly all datastage jobs stored in the unix server?

Hi

How can we import and compile the datastage jobs in Unix?
Are there any unix commands for importing and compiling

Thanks in Advance

Hi

I am working on Lookup File Set Stage, in doing so i am facing a problem.
When i am trying to make a lookup on key column a error msg is populatting like

Key expression cannot be set on key columns of this link.The connected stege defines the key lookup

Can i know the problem?