DSXchange

I am reading from a mainframe file using a CFF stage. then i write the fields to a flat file. then i read the flat file for other purposes. The problem is when i open that flat file with the same table definition as the mainframe, i have hard time reading integers, i have to read them as string then...

I am reading from a mainframe file and write it to a sequencial file. it is a one to one mapping without any transformation. I have the copy book for mainframe file, when i use the same table definition for the target file i run into problems for number fields. the question is, is there a way to mak...

When I create files in DataStage, and opening them with notepad, all are in one line, they are in unix format.

is there a way to write in dos format? with carriage return and line feed characters?

it can be done in server but not in parallel. or at least i couldnt find the option.

Well you could create environment variables for userid and passwords in your .profile or create a .ftp file like this: export USERID='the user id you want to use' export PASSWD='your ftp password' then in your ftp script just call this script by . /full/path/to/.ftp ftp -v -n abc.syscon.com user $US...

rajeevn, I fixed the problem the hard way :) I agree about big-endian, i have done it already, when i view it from datastage it shows properly but when i open it in a text editor i get junk. my workaround was inside the transformer. I read as smallInt then my target file field is Varchar instead of ...

Well, the file is in EBCDIC format, but some columns are in COMP as mentioned above. when I open the definition they are stored as binary. but I read the file as EBCDIC, go to a transformer one to one then write them to a flat file. the definition of the flat file is not cobol format. here is the de...

Well, I found the problem in NULL values in the ebcdic file. i got rid of those problematic columns and it works for now. although it is not a good idea, but i can view my data. now i have another problem. I have this basic job to read from mainframe and convert it to ascii sequencial file, now when...

Hi, I have a complex cobol file in ebcdic format. i have trouble reading the COMP fields. Here is the copybook ETI generated: 01 DCLFRGN-EXCHNG. 05 RECORD-ID PIC X(4). 05 PRTITION-NO PIC S9(4) COMP. 05 SESS-DT PIC S9(9) COMP. 05 SESS-TR PIC S9(9) COMP. 05 SESS-TM PIC S9(9) COMP. 05 TXN-SESS-ID PIC S...