DSXchange

There is.

Look more closely.

pandeesh wrote:Is there any command line option available for finding the duplicates in dataset?

No.

Have you set the "A margin" (location of level 01 item) correctly when importing the COBOL FD?

Are you totally certain that the COBOL FD you have is the one that describes the data you have?

Use %m and %d designators for flexible format.

What is the primary key of the employee_sports table?

Weird! Error code 2 (E_FNTF) is "file not found". I wonder how $PS1 could affect that?

Anyway, thanks for the posting, even from one of the old players!

You've omitted the space at the beginning of the constant time portion.

In DB2 you need to connect to the database you intend to use.

Most IBM products have an Information Center; DB2 is no exception. You can find out all you need to know and more there.

It has substituted the parameter reference. Look at the "job starting" event in the job log to determine what value was actually passed to this parameter.

There is a technique shown in the version 7 Advanced DataStage class that uses three consecutive Sort stages to accomplish detection of the last record in a group. I'll need to track it down and post details.

Show us what you tried. This is readily do-able; particularly easily if the data have been processed through a Sort stage that generates a Key Change column (assuming you're using a parallel job, which is not certain). You can, of course, do the key change test using stage variables. Use more stage ...

You could also convert the commas to value marks (@VM) and write to a hashed file, then read from the hashed file normalized on the multi-valued column.

If they're in there, they're in there. You could include a Remove Duplicates stage in the stream from which the Data Set is read. Preferably you should avoid writing duplicates into the Data Set in the first place, if you don't want them.

How large is the attachment? It might simply be waiting while the file is being uploaded to the mail server.

If it's only " -" and "- " there's a tolerably ugly solution involving nested If..Then..Else and Index() functions. But one which would meet your clients' stated requirements.

<rant>Resist stupid requirements!</rant>