DSXchange

Hi naveen.p

SQLCODE 3107 means that there is at least one message in the message file - check it out and ask your DBA if you do not know what it means.

The message file is a option in the DB2 Connector.....

regards
MT

Hi suryadev, you have to catalog the database on your new DataStage server. This is done "outside" DataStage. On the DataStage server you should have a DB2 client installed to be able to connect to your DB2 data sources. In thios cklient you have to catalog all the databases you are going ...

Yes.

Use stage variables and build a counter like
svCounter + 1 => svCounter
and the you build a condition to your output link svCounter = N

Hi,

with a transformer!

Short question - short answer

Hi ICE,

you are welcome!
I am happy that you solved your problem

Hi ICE, 1. Do you mean that our DS server should have install Chinese font??? Actually I tried to add one Chinese font from Windows font installer but it cannot show the font name even. I do not know why :( => No I think DS is not able to show the characters in general - I do not think this is a way...

Hi kaps you have to read the error message completly main_program: SQL0303N A value cannot be assigned to a host variable in the SELECT, VALUES, or FETCH statement because the data types are not compatible. SQLSTATE=42806 Check the data types your are going to load and their nullability. regards Mic...

Hi ICE, UTF-8 characters are not simple to handle because in your case you do not know wether the character is incorrectly stored in the database or only displayed in an incorrect way. Here are some points to consider: - Do you have a UNICODE font installed to be able to show all the chinese charact...

Hi maurya, it is simple to create a single job for that where you delete data before you insert the new ones (i.e. before SQL) but I think performance is a important thing for that. I do not know which database you use but I recommend to closely work together with the DBA in order to support your jo...

Hi mac4rfree85,

why do you want to trim something which is NULL?
Try this logic

If IsNull(columnName) Then "" Else trim(columnName)

regards
Michael

Hi Vitumati, depending on what you mean with ... But I need to design one sequence to trigger all jobs at a time. you could design a single sequence where you add a sequence to your jobs - even they are independend - in order to decrease the parallelism which will kill your machine (see the other co...

Hi sourabhverma, there is a solution to in SQL: recursive SQL. It is a little complicated but with recursive SQL it will work with any number of levels. I do not know the Netezza database you use but there is a good explanation of recusive SQL in the "DB2 SQL Cookbook". You wwill find it i...

Thanks for the clarification. If i enabled execution mode as parallel for DB2 API stage then is there any performance improvement. I could see default execution mode is Sequential. Hi, the DB2 API stage is a sequential stage. You could tune it by setting approprate ARRAY SIZE and TRANSACTION SIZE t...

Hi, hi One more requirement to this sam tansaction type should have sam batch id .. Even the second by MT did nor work .. well you should not expect a fully programmed syntax and solution - you have to add some more thoughts by your own. The input should be sorted by transaction type. You have to de...

Hi Vidya, you could use the different partitions for your batch id calculation. You could do it by having two stage variables - a simple counter (counter = counter + 1) - batch_id = @PARTITIONNUM + counter*@NUMPARTITIONS Additionally you have to follow Rays advise in order to have all identical tran...