DSXchange

You certainly can use a stage variable as a counter.
Initialize it to zero (type is Integer for Mainframe jobs), and derive it as StageVariable + 1, possibly qualified by a test based on whatever it is you wish to count.

Ray Wurlod
Education and Consulting Services
ABN 57 092 448 518

In a word, yes. It's all in the Parallel Job Developer's Guide. [:)]

Ray Wurlod
Education and Consulting Services
ABN 57 092 448 518

A substring based approach only works in bytes if a single-byte character set is in use. Since the OP is in the USA this is a fair, but by no means guaranteed, assumption. All the substring functions actually work with characters which, in multi-byte character sets, is not the same thing as bytes. S...

Show us how you are getting the date/time. In particular, what are you calling via DSExecute? The @DATE, @DAY, @MONTH and @YEAR system variables are initialized when the job starts, and are not changed subsequently. The Date() and Time() functions always return the date or time now. NowAsTimeStamp =...

Is the source a text file? What version of DataStage are you using? (This affects the possible replies to your question.) Take a look in the Routines branch of your Repository, under the SDKDataType category; you may find something there that is useful. Ray Wurlod Education and Consulting Services A...

Don't forget, in the Director client, to ensure that the Show Categories option is checked under the View menu. Otherwise you get every job in the project, sorted by job name (a large sort in a project with many jobs will help to slow things nicely!). Ray Wurlod Education and Consulting Services ABN...

Of course, you don't need a Rejects output if you don't want the warning message to be logged. It is enough to have constraint expressions on each output link (VoidIndicator = "V" on one, and VoidIndicator "V" on the other, the one that goes to SQL Server). You don't need a hashed file; it can all b...

Lisa, You did not provide any contact information, so I reply here. As you can see from my signature, I do this kind of thing for a living. If you get back to me with details of where, when, for how long, and so on, we may be able to do business. Regards, Ray Wurlod Education and Consulting Services...

Only close scrutiny of the generated COBOL!

The underlying database is no longer called UniVerse, since IBM became the owner of UniVerse and the development of the two products (UniVerse and DataStage) began to diverge. The underlying database is now a part of the DataStage Engine, and has no specific name. Names of the tables are theoretical...

In versions earlier than 7.0 the answer is no. The reason is that PX is built on the Orchestrate technology that Ascential acquired with Torrent, and this technology did not know about DataStage BASIC. There is more integration in version 7.0, due to hit the streets any day now, and the answer will ...

Having created the two jobs that Kim suggested, you could also create a job control routine that detected which format was being used, and start the appropriate job. For example, if you're on UNIX, you can use the head command executed via a call to DSExecute to read the first line, and parse this t...

Only close scrutiny of the generated COBOL! [:(]

Ray Wurlod
Education and Consulting Services
ABN 57 092 448 518

Given that the ports are assigned dynamically I don't think you have much choice other than to have a script run on re-boot that detects the port number (after SQL Server starts) and edits the .odbc.ini file. This is not something with which DataStage can (or ought to be able to) cope. Ray Wurlod Ed...

CREATE INDEX (the SQL variant) will create an index on multiple fields, but you have to name them both in the statement. You can also specify the sort order for each of the indexed columns' values. For example: CREATE INDEX indexname ON tablename (colname1 ASC, colname2 DESC); However, for this to w...