DSXchange

Process every field as VarChar, then use a Sample or Transformer stage downstream of the FTP stage to skip the first row. Reparse your data after that (or in the Transformer stage) as required.

That message is being returned from DB2. I suggest you concentrate your diagnostic efforts there. For example, has a password expired?

The code is not correct. You need vParamName, not vParamList, in the call to DSGetLinkInfo() function.

Because you've used "Param" variable names, your code is confusing. You should prefer vLinkList and vLinkName, since links are the objects with which the code is dealing.

What does 020802 actually mean? Is it YMD, DMY, MDY format? Is it a Julian date of some kind?

You need DBA primarily to create projects (to execute CREATE SCHEMA under the covers). You also need it to use FIX with VERIFY.SQL. Most GRANT commands require DBA privilege. These are the important ones for DataStage. DataStage *should* automatically grant DBA privilege to any user with DataStage a...

All that changes if the configuration file mentions an import and/or export pool.

You can create routines but, without a correctly installed and configured compiler, you will not be able to compile the routine.

The Performance Monitoring tool within DataStage will give you all of the things you mentioned.

What happened between when it was working and when it isn't working?

I've just taken Brad through a very similar situation, which was resolved within the last few days. Why not search for UV_USERS ?

The constraint for your regular output link is simple logic. (IsNull(InLink.Col1) And IsNull(InLink.Col2)) Or (IsNotNull(InLink.Col1) And IsNotNull(InLink.Col2)) You can use an Otherwise/Log output link to capture the other case. Derivation of the target column Col1 is a simple If..Then..Else. If (I...

There are two variants for VERIFY.SQL at each level of object. In one, you give the name of the object in the catalog, in the other you give the pathname of the object in the file system. Which you use depends which problem you're trying to solve. (It's all in the UniVerse SQL manual, but nowhere in...

Yes, you're wrong. No product is able to transfer data between two sources which might have different character set (from each other). Unicode should be used when the data being processed can not be represented in a single-byte character set (and even sometimes when it can be). More information abou...

Experiment. Add one or more default values in a job, save the table definition, then open the table definition and use the Layout tab to inspect the record schema. Please let us know the answer.

Would it be possible for you to obtain a premium membership so that you CAN read all of my reply?

Premium membership is the main way in which DSXchange's continued existence is funded.

Search for UV_SCHEMA and UV.ACCOUNT too. One of those three will find a solution for you.