DSXchange

It depends on which version you are running, on whether the compiler directive $OPTIONS NO.CASE has been asserted. I always have case sensitivity switched on.

You might also find this post informative.

Does this problem occur from just one client machine, or from all?

The message is fairly obvious; something in your query is generating a value that is too large. Assuming you are using ODBC, there is a maximum row size and a maximum number of columns that can be transferred. These maxima can be configured in uvodbc.config using the MAXFETCHBUFF and MAXFETCHCOLS pa...

Never tried it. Check the internal job number. If it's the same in both versions there is a chance it will work. But there are no guarantees; you are not supposed to be able to regress versions in DataStage; you should have good backups before upgrading.

Welcome aboard. :D You can find the dsjob command documented in the Server Job Developer's Guide or the Parallel Job Advanced Developer's Guide If you're on the DataStage server machine, you can use dsjob -report projectname jobname If you want to execute from somewhere else it's dsjob -host yyy -us...

"file.ds" is not the Data Set. It is the Data Set control file. (And it's definitely not junk!) The data in the Data Set are in separate files in the directories identified as disk resource in your configuration file. These, too, are in DataStage internal form (binary numbers, for example), so you w...

Have you specified nulls sorting first or nulls sorting last? Add an ORDER BY a clause to see whether that makes any difference.

Are you sure that you've specified the delimiter character correctly in the job design? (Remember that there are three delimiters; field delimiter, final delimiter and record delimiter.) The message suggests that the job has read 100000 bytes without even finding one delimiter character. I'd give up...

Always Routines!!! Create a server job to get the maximum value (no point creating a parallel job to process one row). Have this job put the value into its user status area. Use the $UserStatus activity variable to supply the parameter value. Have you thought through the appropriate mechanism for ge...

There is no function. You could, of course, write your own.

You can write raw strings to a file. You can subsequently read data from that file though, if you don't have an appropriate record schema, you will need to read a single VarChar column.

The conversion is attempting to give you 12 decimal places. In the second case you are getting rounding errors to an acceptable degree of precision (which you can prevent with coding). The first one looks like a bug; maybe you need to test for the absence of a decimal place holder and add a decimal ...

That tells you something about your userid and its rights to use SAP, doesn't it?

Does the one row in the output file contain all the data from the ten source rows? That is, have you misconfigured the record terminator character?

A quick (not thorough) search through the manuals has failed to find this term. Can you seek help from your support provider, or possibly from IBM certification email address?

Welcome aboard. :D First things first. Can you connect using the Administrator client? (This uses a different mechanism, not initially attaching to a specific project.) Can you establish a telnet session to the server, cd to the directory where you installed DataStage server, and execute the dsenv s...