DSXchange

Server job (as posted) or parallel job (as marked)?

Ask N one-armed economists* what the economic future of the US economy will be. You will, of course, get something of the order of 3N opinions. Curiously, DataStage historically has fared well when times were tough - it's main growth was in the 1990s, when the world economy went through a slowdown. ...

Precision can also be an issue; there are precision limits on decimal number. In your example you will be introducing a requirement for an additional seven digits of precision (since you are multiplying by 10**-7); does your output field data type cater for that?

"Performance statistics" in Designer are only cosmetic anyway (prefer to rely on the row counts available through Monitor). Did you enable display of these (from the Diagram menu) for this job? You might also post your job design, so we can see what other stages may be involved. For example, if you ...

Look at the Job Control code generated for the Batch. Seek out a variable called ExtraParameters. It is being used without first having been assigned a value. Does your batch have a parameter called ExtraParameters which has not been given a value when the batch is run? Note that this is NOT Transfo...

Please enclose the Actual Row in Code tags so we can see the extra spaces. However, the hex dump does not show any byte over 7F, which means that code page 1252 should have no problem at all with these particular data. 9 39 9 39 5 35 1 31 0 30 0 30 0 30 0 30 3 33 20 2 32 : S 53 H 48 O 4F R 52 T 54 2...

I gave you two commands. You only executed one of them.

Premium membership is not expensive, at less than 30c per day. It is one of the ways that the hosting and bandwidth costs of DSXchange are met, and well worth considering.

It would appear that your job is having a problem connecting to the database server associated with an ODBC driver, perhaps due to a network problem.

Why do you claim that "parameter values [are] not being passed"?

"#" does NOT introduce a comment in DataStage BASIC. Looks like the dynamic array was being passed back while testing, since this line is now commented out. I often pass dynamic arrays - it's a more convenient mechanism than most others that are available. The -1 syntax in dynamic array assignment m...

Oconv(Iconv(Field(DSLink2.Field1," ",1,1),"DYMD"),"DQ") Or, if you want an ISO 8601 "quarter tag" format (YYYYQn): [code]QUARTER.TAG(Iconv(Field(DSLink2.Field1," ",1,1), ... Thanks ray As I am coding as quoted like, Oconv(Iconv(DSLink2.,"DYMD"),...

No-one on this thread claimed that there was a Remove Duplicates stage in server jobs.

On the server console, adjust date and time. (This was a facetious suggestion.)

Look in your configuration file. In the third-named node, discover the pathname of the "resource disk" directories. Whoever set up your system imposed a quota (maximum bytes that you can use) on at least one of those directories, and you have reached that quota. Delete some un-needed Data Sets, or g...

Data Set data files are stored in the directories specified as "resource disk" in your configuration file.

What about all the IBM registry keys?