DSXchange

srekant - instead of getting an explanation that would be a copy of what the documentation states, just do it - run the job and then go into the dataset explorer or use orchadmin to see what the resultant dataset looks like. Column propagation is a wonderful and powerful tool that, unfortunately, ca...

srekant,

the runtime column propagation does not populate output tabs - they are implicitly passed on between stages. This allows you to actually write jobs with stages that show no columns, because they are passed onwards downstream via the propagation.

Hello Ray - I hadn't tested that in Server; I just used that several times in parallel jobs (using a lookup stage) and assumed that it had also been changed for Server jobs & transforms. Sorry snassimr for giving you unqualified advice...

divine,

you can access the DS.TOOLS command from your Administrator execute command selection.

Please lookup up the documentation on the DSGetLogSummary routine - especially the description of the third parameter. Then compare that with the output of your DSGetJobInfo() call.

Hello there Jayant, you can use the INDEX function in PX, the syntax is the same as that for a server job, INDEX(BigString,SearchString,Occurence) -> i.e. INDEX('This is a long string with Product numbers in it','Product',1) will return 28 and it will return a 0 when the SearchString does not occur ...

You can use the result of the first lookup as an input to the second; you will need to make sure that the order they are executed in is correct [you can do this from the TRANSform stage order icon].

snassimr, in order to convert to a data type, you need to know what format the source {binary} datatype is in. Binary usually just means that it is not displayable; but that is not enough to know what conversion to apply. Where is your data coming from and what is the datatype in that source system ...

Are you doing a EBCDIC to ASCII conversion on the file or column? What is the data type for the column with the high value? It is odd behaviour.

Are you doing a EBCDIC to ASCII conversion on the file or column? What is the data type for the column with the high value? It is odd behaviour.

Morning Prashantoncyber, the first message you are getting is because you have turned on column propagation; you either need to remove the duplicate column or turn off propagation. In your second run, it looks like you have declared a dataset but are trying to read a sequential (.txt) file. You need...

Carol, DataStage hash files are stored as either one or two file system files; thus if your file system limits files to 2Gb then you might get a problem there. In addition, you can also specify a 64BIT file pointer size with very large hash files if needs be. Your proposed file, while quite large, i...

It returns a 0.

ghutchin,

the CFF won't do the conversion - so if you were to look at your file from an editor that shows control characters you will see that that culprit is not the CFF. Are you doing an FTP - perhaps doing a EBCDIC-ASCII conversion? could you do a binary transfer & convert from within DS?

Lory,

if the column is not nullable and the lookup is not successful the default value will be returned for each column. I am not at a terminal right now, but for char that is, I think, a project default of char(000) and varchar would come back with a length of 0