DSXchange

This might be a case where you could think about using a Server job, at least to read and process the Cobol file. I've never heard of Comp-6 but if it is a simple 4-bit packed representation as stated in the comments then you can use the DataStage Server builtin routines to convert the "binary" repr...

beaditya - let's take a step back. Where do you want this row value returned? A transformer gets executed for each incoming row. You could do an after-stage subroutine call and pass it the value of @OUTROWNUM. But all this depends what you want to do with the maximum row number.

The LOCATE statement works with DataStage dynamic arrays. The elements of these are separated by certain characters, @FM, @VM, @SM and @TM for the 4 different levels. The comma you are using is not one of these, which is why the statement isn't working as you expect. Try WorkString = "123,456,7...

Table1 and Table2 are different in your DataBase. Different numbers of records and perhaps you have different internal table setups / indices as well.

You should be using "<>" instead of "=" to reject those records. You do have a stage mnemonic called @OUTROWNUM that you can use in the transform.

the DS engine will not start up with processes attached in the FIN_ or CLOSE_ wait statuses. Have you brought down that instance? Also, which flavor of UNIX are you using - I recall issues with HP-UX where an OS bug prevented these sockets from being released.

Is the datatype perhaps NCHAR? And what is your character encoding in both DS and your database?

Oops, I got the order of the parameters wrong. Sorry.

A "?" in view data from the designer can denote a character that can't be displayed. Where are you seeing this question mark?

Thats a tricky one. A little Math can also help here. Ereplace(Ereplace(Ereplace('132,21.32', ',','*'),'.',','),'*','.') gives you 132.21,32 If you really want to go the text route, use CONVERT('123,456.78',',.','.,') , is it simpler and more efficient. I still think...

There is no such code generator, but if your metadata has been loaded into the repository creating such a job as you described should take no more than 1 minute. Drop source type on the canvas, ditto for target. Fill out source/target path and file information, load in the metadata and link the stag...

"LIST DICT" and "LIST.DICT" are synonyms. The default sort order for the DICT listing happens to be the same as a simple SORT command, so produce the same ordering.

Add 0 to it in a transform stage or TRIM(Column,"0","L")

At version 7 the repositories for metadata and job information for both PX and Server reside in DataStage (which used to be UniVerse but has split). There is no advantage or disadvantage since you have no choice of where the repository, as of Version 8 (formerly code-named "Hawk") you will have choi...

This looks like you are trying to make the number look German. Without having NLS enable, try OCONV('1234567','MD2["$",".",",",""]')