DSXchange

If there is no line terminator then there must exist some indicator of the length of the variable part. I don't believe the CFF stage can deal with these as yet. However, you can read with a Sequential File stage as a single string per line and parse subsequently with a Transformer stage. Thanks Ra...

This symbol? :? Funny...that is exactly how I am right now...puzzled!! :wink: CHAR(10) would be a LF but you shouldn't have to use a function to specify it. A CR is a CHAR(13) btw. I don't use this stage and the documentation is a little sparse, so I'm gonna have to guess on a couple of things. You...

Look at the file with a hex viewer (UltraEdit is good) and determine what the line terminator actually is. It can't be NONE, because of the short records. Thanks Ray. I tried to look at the End-of-Record using Textpad, but it showed me this symbol and I couldn't find it in the ASCII chart. I will t...

You might be better off finding out why you have short records. Fixed is fixed and that means each record needs to always be just that - a fixed constant length. Can you verify if they start off that way on the source system? FTP can strip rather than preserve trailing spaces in records and thus ho...

Gurus, I need help with regards to the configuring of CFF Stage, specifically how to configure when a Fixed-width file will be occasionally missing the last two fields. Scenario : We have a fixed-width file being FTP'ed by Mainframe onto a server and that flat file is being successfully processed by...

True...and from what I understand from the documentation, ODO clause will not get flattened as opposed to using just the OCCURS clause.

Well...you are right Craig in the sense that, you have to flatten Occurs in order to read the data. CFF does that flattening work for us. Now, in 8.x, IBM has included the support for the following: > GROUP > REDEFINES > OCCURS > OCCURS DEPENDING ON However, I too have a limited experience using CFF...

AFAIK, both 'occurs' and 'redefines' are not supported. Craig, CFF stage supports Occurs as well as Redefines. I did not understand what you exactly meant by "not supported"! Now you are treading into deeper water. Complex flat files (with occurs, etc.) are handled in a more proprietary w...

Find something (DataStage?) to read the xml metadata from the other tool. Manipulate that metadata and create whatever other file type that you are most comfortable with..... study a .dsx....... Ernie, Thanks a lot for your help. I am trying the "STUDY DSX AND EDIT IT" approach and I code...

Ernie, I have the following questions regarding your answer. There are lots of ways to get metadata for tables "into" DataStage, among them being reverse engineering of a table .dsx (export one and take a look at it --- it's not that difficult -- and also has been discussed in the forum in...

Hi, Anybody suggest me how can we slove the below error : Abnormal termination of stage Jobname.transfermerstahename detected Murali, After any such errors happen, if you simply re-set the job, not run it again, you might get a log of what that error is. If you are having any such error log being d...

Well it was worth a shot. Now to convince them to use scripting. Thanks for the help. Craig is right. I had the same issue with FTP stage, when I am trying to do the FTP commands like "quote site". IBM told us that it is a limitation of the FTP stage (cannot execute the FTP commands). So,...

...to check for a zero byte file which is received at datastage inbound path. You can also write a routine in DataStage and use the OpenSeq functionality in it. There is a STATUS array and one of the fields in that array is 0 if the file is a zero byte file or not. This is a little more complicated...

chulett wrote:Realize that he said it may do so, not that it does. Hence the suggestion to check with support.

Okay! I misunderstood the "may be" portion
Thanks all for your help! I am marking this topic as resolved.

I would expect Iconv() or Oconv() would be used with server job stage types to effect unmasking of decimals and various other conversions. So, yes, even if you're using OCI, it may be so. Thanks Ray. It is indeed very interesting to know that beneath the covers, even for an OCI stage, DataStage use...