DSXchange

Which part of your sequence is generating the warning; most stages will let you differentiate on the return code and issue your own call to abort the sequence.

There are a couple of methods you can use to get this. If the SQL is a quick one, you could issue the SELECT to return a COUNT of rows and then call a DSLogFatal() in a transform stage. Or you could start this SELECT as a distinct job, and then use DSGetLinkInfo() for that job/stage/link to get the ...

DataStage will perform an implicit conversion from a string to a number and vice-versa.

The error message is telling you that the object

db2home/db2inst3/sqllib/lib/libdb2.a(shr_64.o).

is either not there, has too little permissions for your user or for some other reason isn't accessible. Have you checked your UNIX permissions?

Don't forget that you also need to execute a "db2 connect ..." statement as well!

I've gone through all the registry settings, looking for either an explicit integer value around 5 or for keys that might allude to this; all to no avail. I've seen all the previous connection information so at least it is there, but no way to modify the drop-down list. I'll submit a call and see wh...

I only have the one for 751 so cannot help you. If it is an emergency then you will have to contact your support provider. Also, have you looked at your installation CD to see if the file can be retrieved from there?

Have you tried to login to TOAD or your favorite tool with the same id and seeing if you get the same problem when looking at the DDL for the table or when issuing the same query?

Just call DSExecute from your routine.

sudhakar, both errors are common in EE. The first one is that you have stated that Field001 is nullable, but you haven't told DS what to do when reading froma sequential file. Do a "edit row" on that column in the sequential file stage to set the attributes. The second means that you have a metadata...

What does the stage in DataStage show for the datatype and length and what does a describe on the table from your favorite SQL query tool show? There will be a difference.

What was missing from Roy's post, in your opinion?

I was looking at the other FTP stage. Have you specified "fixed" for the record length attribute; this is what I have done in the past and I did not specify "implicit" for the record type attribute.

What is your setting for the FTP stage Inputs -> Line Termination?

I've been searching the registry entries looking for the key which I might be able to change in order to get my history of connected hosts/projects increased from the value of 5 to something quite a bit larger - I'm tired of trying to recall all the different host/project/port combinations and of ha...