DSXchange

IBM offer a training class, code DX710, from which you take away a training manual plus lab exercises.

Now we need to know the data type specified for your single field. I would imagine, as you did, that if it's integer then the rows containing non-numeric characters should be dropped or sent along a reject-handling link. I have reproduced this, it also occurs with the record delimiter property set t...

You can do that in DataStage also, though why I have no idea. The system variable that you must use is @NULL.STR. For example: If IsNull(A) Then @NULL.STR Else A : If IsNull(B) Then @NULL.STR Then B or, more simply: NullToValue(A, @NULL.STR) : NullToValue(B, @NULL.STR)...

It is not possible, it seems, to create a Data Set with zero records. Add a dummy row to each, and ignore it when processing. Submit an enhancement request to IBM, through here or through your support provider.

It is obvious WHAT is happening, WHY is far less apparent. What is the field delimiter, quote and final delimiter character specified? Please also advise the record delimiter property value. Then we can try to reproduce.

The only possible explanation is that whatever you are doing is inserting the zeroes. With such a vague description (and even vaguer subject) it is impossible to diagnose more accurately than that. The computer does precisely what your programming tells it to do. Therefore, if you need more focussed...

You can not concatenate @NULL to anything without the result being null. The middle condition of your expression would do A:@NULL, as you noted. What you really need is If Len(A:B) = 0 Then @NULL Else A:B To avoid calculating it twice, you could evaluate A:B in a stage variable. This solutio...

The hashes might be being put in by DataStage, if that's the pad character setting. If the table definitions were imported from sequential files, that is a significant possibility.

Using a HEX EDITOR

Wait...
leprechauns are green
so they can't be leprechauns at IBM

little blue men?
Nac Mac Feegle!!!

You will not only need a different CD, you will also need a different licence.

They will probably give you the CD.

Be prepared to hand over several buckets of cash to buy the licence.

There will always be an overhead. You cannot process large (or even small) volumes of data without demanding some resources to do so. Simple economics. Try a number of techniques, benchmark and measure them in your environment, and make your choice based upon those results. "There ain't no such thin...

No.

You must specify the server hostname (or IP address) to which you wish to connect your client.

The clients "remember" (via Registry entry) the most recently successfully used hostname entry, and displays this in the hostname field when re-connecting.

You already have it.

Read the help on the FORMAT command, in a CMD shell.

You already have it.

Read the help on the FORMAT command.