DSXchange

Hi, In my sequence there are two bulk load jobs(Job A and Job B) running in parallel. Both the jobs are Truncate and Bulk Load Loading to a DB2 table hosted on AIX However the load job A failed due to table name issue. So corrected the issue and restarted the sequence.The corrected job A ran fine bu...

Have come across the same problem.Using Nvarchar solved the problem

Thank you all for your suggestions.
Would try the possible solutions mentioned and implement the suitable one.
Marking the topic closed

Hey Craig, To clarify..when I say running a script from director, I have created a sequence job which has Execute_Command wherein I mention the script. Yes I can use warn(0) parameters along with the dsjob command which may not be a good practice to adopt. The topic which I am confused is "When...

While reading data from a fixed width sequential file, have got warnings and crossed 50 and the job got aborted. The next stage to sequential file is a transformer stage and also there is a reject link on the source sequential file stage. The flow of execution is as below A script executes the comma...

Sorry for delayed reply.
I could not find these settings in toad for db2.
Is there any other way I can fix this.

For now I am extracting all the data and applying the filter in datastage transformer stage and is working as expected with correct results

I am using Toad for DB2 to execute the query. Not sure how to get the NLS for that session

Thanks. It worked :D

Hi, I am able to catalog a database from DS AIX server. The query is "Is it possible to catalog two databases with same names which are mounted on two different servers".If so how can I do this The situation is as below Server 1 : ABC DatabaseName : APPLE1 Server2 : DEF DatabaseName : APPL...

There is no warning returned.
and with CAMPA% no rows returned

Hi All, When I am executing a query from db2 connector with read query from sql and direct query, the result sets are different. The query has an xmltable and on the result set applying a where clause. When the query is executed by reading from file the where clause applied on xml table result is no...

Thanks a lot Mike for the clarification.

Hi, I have few queries on Change capture stage. The documentation of IBM says that change capture is performed between two datasets Is it mandatory that the change capture should be performed only between datasets? I have implemented using a dataset and a db2 data source. The number of records are a...

Hi, I am executing datastage job by command line commands from Unix script. I am writing the datastage logs to the Unix physical file by using the command logsum. The issue is when the error or information is longer, I just see a few dots like JobControl (fatal error from DSAttachJob): Job control f...

Craig, There are no parameters in the file. Mike, I create the view at the run time because there is a subquery within the view creation which has a where clause for range of dynamic dates, which currently I am taking care from a script to change these dates and create the sql statement file. This f...