DSXchange

In the sql. You can find the syntax by searching in google.

Yes. The ones which are suffixed with an astrix (*) means you can send in a string. You can specify your input variable as char* and send it any length of record you like.

Who said you cannot pass arguments to C routines that are pointer types? If you look at the Argument's tab while creating a px routine, you will find Input types as char * and int * etc.

Welcome Aboard
You can do this in any database stage in before/after sql tabs. The sql will be whatever works for you.

You can insert a null value. Do an explicit check with IsNull() and then SetNull() if its a nullable column. If its not then your requirements will state what to specify if null is encountered, specify that as null_value in the extended properties. It can also be specified using NullToValue() in tra...

Did you try binary?
Also try doing a CAST statement in your target sql and see if that helps.

Same here, have no idea whats going to be on windows. Your system admin should be able to help you with that.

Well it might be one of those days when you hear that something can be done with a particular stage. But the information was'nt comple as to on what animal. I clarified that

Strange. Contact your system admin to get this resolved. Its in your usr/bin. You should be able to invoke it

I stand corrected. Your right, mult-threading is processed by a single control where as multiple instance is synonymous to making clones. Great example Ken.

How are you compiling it. You need to compile it by using xlC_r. Remember its case sensitive.

Check the path of APT_COMPILER in your datastage administrator. This env. variable holds the path to your compiler.

Did you recently stop and start the DS Engine? If yes then you need to explicity start the JobMon by issueing "./jobmoninit" command. Thats how it works on unix. I am assuming the same is true for windows.

You know Craig, this is a real bummer. I hope they fix this in the next release. There has to be a workaround for it.

See if thispost helps.