DSXchange

Ok, I agree that the file i use is not a fixed widht file.

wen i have a file which has variable length for records, wat needs to be done, so that DataStage can read the file without any problem.

Hi all, I am using a fixed width file, which has only one column of length 200. I have some records which have length as 30,some as 45 some as 90 and some as 40. When i run this job, i get the following fatal error : Sequential_File_11,0: Short read encountered on import; this most likely indicates ...

1.is it possible to convert rows to columns?if so which stage shuld I use? 2.I have a file which has only 1 column of length 200.I have about 20 rows in the file, all the 20 records have record length till 65, I got the fatal errors - --------------- - Sequential_File_9,0: Short read encountered on ...

is there any way i can comment a derivation written in transformer stage or some other stages? Note : In Informatica, we use // or -- to comment an expression written on expression editor/ or any transformation... Where can i get the usage of each function in DataStage, with exapmles? pls answer! Th...

Hi, I have this scenerio : I want to use a Dataset as the target in my job, which gets loaded in the first stream/pipeline of my job. In the same job, I want this target as a source and load another dataset. Is it not possible to do it in a single job? Becos I got an error and wen i spliited the job...

Are there any separators in between the columns or it is a fixed length file. You can read the entire row in the file as a column and after that you can process individual columns separately. With such a case you can still have same structure for both of the files. Hi loveojha2, ur reply was useful...

Hi all, I have a doubt regarding the source file layout. I have 2 source files F1 and F2.The total length of all the columns in F1 and F2 are the same, but the no.of columns are different. Suppose F1 has this layout : columnname length col1 200 col2 50 ---------- columnname length colmn1 100 colmn2 ...

1.what function I need to use for looking on a string/variable for a given input. for eg., I want to check whether the string '0123' is present inside a variable which has a value 0123456? which function shuld I use? 2.which function shuld I use for replacing the character by another? for eg., in th...

ray.wurlod wrote:Your "failed lookup" rule is set to "Fail". Change it to one of the other three values. If you select "Output" you will need to construct a reject output link. ...

Hi Ray, ur reply was useful.thanks for the same

Hi all, I have created a job and after it ran completely, wen i c the job in the designer, i can see the links are green in colur (i was told that if the run is successful, the link will be green in colur). the link also shows that some x records are loaded, but the log says "fatal error"?...

Hi all, have a nice day! I am beginner in DataStage. I got follwing fatal errors wen i used the lookup stage. -Lookup_3,0: Failed a keylookup for record. Lookup_3,2: Failed a keylookup for record. Lookup_3,1: Failed a keylookup for record. Lookup_3,0: the runLocally() of operator [APT_LUTProcessOp i...