DSXchange

Ask yourself how a COBOL program would read this file. It's not easy if the line length varies. You need to read it a byte at a time. Getting a better format from the mainframe is your best option in terms of least DataStage work. You could pre-process the file in DataStage (using a routine), but th...

MetaStage

You can certainly use environment variables for passwords; indeed, the Administrator client allows you to use encrypted environment variables. Use this as any other environment variable job parameter reference; in a passive stage the reference must be surrounded by "#" characters. If you always use ...

Just for completeness, there is a SQL Server Enterprise stage available on the Windows-platform DataStage EE.

Tell us how you are achieving this concatenation and how you have your Data Set partitioned.

Scratch disk should be empty if no jobs are running. Disk is used for persistent Data Sets and File Sets (including Lookup File Sets); pathnames for their Lfiles are stored in their control files, so they should be findable. That said, recommended best practice is always to use the same configuratio...

I think the lookup_string_from_int16() function in a Modify stage would do brilliantly here. Pass all the looked-up columns into a Transformer stage where you can then combine the required ones into the desired row based on If..Then..Else conditions.

nvalia wrote:Pls reply ASAP.

"ASAP"

Indeed. Guidelines suggest that you should use "hash table" only with fewer than about 1000 distinct values of the grouping column(s) per MB of memory.

The FAQ Discussions forum is not the place for general questions; it is a forum for suggesting particular topics for the FAQ forum.

I propose that the FAQ Discussions and FAQ fora be locked for a period - maybe a month - so that this point can be driven home.

ReadRecords is not compiled/cataloged in this project.
The third argument is the result.

Please post in correct forum.

Is CODE a reserved word in your database?

Different for all different platforms (AIX, HP-UX, Solaris, Linux, Windows, etc.)

It's called mainframe.pdf and it's among the standard manuals. Otherwise search on the IBM web site.

Folks, that's not how TX works. RTFM please. rajnivas may have more luck posting this question on DeveloperNet where there are more ex-Mercator folks posting.