DSXchange

Write failure can occur for a number of reasons. The obvious one is that you don't have write permission at the operating system level. It may have been created as a UV table to which you have not been granted the requisite SQL privileges. It can also occur if the hashed file has become corrupted, o...

Make sure that the column names are correctly quoted. Click the GetSQLInfo button. At worst, insert the backquotes into the Derivation column on the Columns tab, or use user-defined SQL into which you've pasted the backquotes. Don't forget the Selection tab; any SQL you've placed there must also hav...

This is NOT a DataStage problem. Nor does it have anything to do with the fact that you're performing lookups to hashed files. You are trying to send too large a transaction to Oracle. Possible solutions are to have you Oracle DBA enlarge the rollback segment so that it can handle the size of transa...

One of the required properties, somewhere in the Activity, is missing.
Or an expression is not syntactically correct. It should be highlighed in red either way. Find it and fix it.

Provided there's a VOC pointer to your hashed file you can use the Trans() function. Trans(hashedfilenameexpr, keyvalueexpr, 1, 'X') hashedfilenameexpr is an expression that evaluates to the VOC name for the hashed file. keyvallueexpr is an expression that evaluates to the key value to be re...

Next time your project is reviewed, simplify the code and reap the throughput performance benefits.

Look at the generated SQL. Does it have any TO_DATE or TO_CHAR functions? The message indicates that the date you are supplying does not match the date picture in a TO_DATE function, for example the date picture may be 'YYYY-MM-DD HH24:MI:SS' but your data only has one digit in the month position. T...

You will note the word "Filtered" in the status bar at the bottom of the screen. Use Ctrl-T or right mouse click in the list view to open the Filter dialog box. The rest is obvious.

It's really quite amazing what you can do with generated SQL if you put your mind to it. All you have to realize is: the Derivation column on the Columns tab becomes the SELECT clause (so you can include set functions in the derivations) the Table name becomes the FROM clause, so you can use comma-s...

The output file needs to be constructed in three parts. The header record. One job or routine. Create file. The individual account records. One job sequence. Append to file. The trailer record. One job or routine. Append to file. The job sequence to process an account is similar. It could be an ordi...

Try one. Find out.

Use an ODBC stage to connect to SQL Server. In the Transformer stage check the "multiple rows for lookup" check box on the link properties.
Read the on-line help topic covering multiple rows for lookup, or search this forum where it's been described on a number of occasions.

That suggests that the problem is in TCP/IP authentication, which is handled (for DataStage) by the DataStage Resource service. Does restarting the services help?

Your blip is accurate. BCPLOAD still works with Sybase which is why it's still in DataStage.
A "bulk loader for SQL Server 2000+" probably belongs on the wish list. You can do that here!

This message may be innocuous, reporting that some form of wait ended.