DSXchange

Yes, you need to change APT_STRING_PADCHAR to a space: 0x20

Your requirements are bad for a CHAR. If your database target was a varchar, then yes you could 'discard trailing spaces' easily.

It's a char field... that's how they work. Everything is fine.

Success. 2 is with warnings, 3 is aborted, etc. All are documented in the dsapi.h 'include' file under the DSEngine directory.

That's because it's inside quotes and thus just text. Build the string properly so it can be resolved:

...Failed !\nBody: " : SummaryArray )

Yes, 8.5 client and server.

DataStage uses a semi-colon for concatenation, let the Expression Builder put it together for you if you are unsure.

Are you current on your fix packs?

First suggestion, search. An exact search here for "Nonnumeric data when numeric required" in the Server forum will get you your next steps.

Parameter sets were introduced in the 8.x release, so no. You would have to code something to read the file and loop to build each -param name/value pair.

Please don't post in all caps, it is considered SHOUTING.

Now... are the only "special" characters you need to remove the ones you posted in your example? If so, the Convert() function will handle that easily.

Should be fine, provided you add the missing @.

For the record, here's the fix: I would just like to thank you for your posting to my "popup" window issue! I went through the registry and identified the entries that were in error and removed them! now it appears that all the popup windows that were missing are now back! Many thanks for ...

Ah... true. There are no leading zeroes.

Tell us what you do have by posting the information Andy asked for.