DSXchange

You were too late. You had to resize it before it reached 2GB. Now it is in a corrupted state, so that must be fixed first. If you can afford the time to reload the hashed file completely, the quickest way is to clear the hashed file, then resize it while empty. Otherwise, those backward link errors...

Well, that certainly looks like Max(F3) from where I'm sitting!

You are misguided about discarded input columns consuming resources in a Transformer stage. A Copy stage can drop columns at no cost.

Because the table name contains a space, the entire table name or column name must be quoted. If one were to follow the ODBC standard, which was written by Microsoft, one would use double quote characters, for example "TableA"."purchase order" - if that doesn't work, because Microsoft does not follo...

It is not possible. The Modify stage does not support the use of job parameters.

Search the forum for a routine called OpenSequentialFile and use that. It handles all possibilities.

The actual statement you require is WEOFSEQ, but there are other possibilities you haven't even thought about thus far.

hhh wrote:Have updated my code with code tags and comments.

Oh, no you haven't!

That's because the command you needed was dsjob, not dsadmin. There is no such command as dsadmin.

My previous post does explain briefly. Invest the less than $1 per week in a premium membership.

The bit datatype uses the most significant bit in its byte. This is the sign bit. In a twos-complement machine the bit pattern 10000000 represents -1. There's nothing you can do about that. Why not apply the Abs() function?

Hi, you mentioned a database sequence, how would you use database sequence in datastage? Do NOT provide a key value from the job. Use user-defined SQL. INSERT INTO tablename (keycol, col1, col2, col3) VALUES (seqname.NEXTVAL, :1, :2, :3) There are three columns defined in the DataSt...

Welcome aboard.

The dsjob command is fully documented in both the Server Job Developer's Guide and the Parallel Job Advanced Developer's Guide.

Look there or search in the forum.

If this is truly time, then the maximum legal value is 23:59:59. If you need 30:00:00 you're really talking about "interval". There is nothing out of the box in DataStage for working with intervals but, because times are stored internally as seconds, then Mod() and Div() functions can be used to gen...

The most efficient, if you want to start from 1 for each run, is to use the system variable @OUTROWNUM, since it is keeping that count in any case. However, if you want a genuine sequence (starting again from where it left off), then either the SDK key management routines as mentioned, or a database...

Your code is confused. For example, consider what this code fragment does if the pathname exists. What did you want it to do? OpenSeq PathName To FileVar Else CREATE FileVar ELSE ABORT WriteSeq InfoMessage TO FileVar ELSE STOP End CloseSeq FileVar Do you REALLY want to work with files in the root di...