DSXchange

Hi, Need to extract data from a view. Want to create this view using the Before SQL option of DB2Connector stage by reading the create the statement from a file. The job fails saying The object name(here the view) is undefined. My understanding with BeforeSQL statement is, the statements defined in ...

Thanks Craig

Hi, Below is my requirement. Execute a query by reading the query from a file in DB2 connector stage and writing to a sequential file. But the catch is I have a where clause in the select query and pass parameters at run time to this where clause. For example : where search_column like #PARAM# Could...

Thanks Craig and Eric.
Marking the topic resolved

Thanks for the space() function and also I think option concatenation with a null value may not work.
PAD_CHAR helps for right padding. I am looking for a left padding option

Craig, Overlooked the link. Thanks for sharing the part. For performance noted option B better Still intersted to know if there is another option to avoid hard coding or is only the option considering below scenario Just in case the target field is a 200 character length and has 50 input characters,...

Hi Craig, Decimal datatypes auto pad with zeros while integers do not. Yes, if defined as Decimal/Numeric, it does have the decimal point which is not preferred along with a space for the sign And in case of strings, padding by default is to the right as defined by the $APT_STRING_PADCHAR I am not a...

Hi, I have a query while creating a fixed width file 1. If there is an integer field(or even a char type) of length 6 how do I get 0s(or another padding character) appended to the beginning Ex: Input : 1234 Expected Output : 001234(Length of the target column is 6 ) I have tried the options a) Str(0...

HI,

Thanks for the response.
I am able to create the dump file in the database server.

I still wonder inorder to capture all the rejects, I have to go through exceptions table and also dump file and is there a way to capture all in once place

Thanks a lot for the help.

Hi Craig,

The directory exists and the user has permissions.
The other log file is created in the same route and with teh same user.

Where should the dump file be created-On datastage server or database serve

Hi Michael, I have mentioned the dump file as /log/blk_dump. This path is on the datastage unix server The job failed with below errors DB2_Connector_6,0: Error 9 occurred while closing the named pipe. DB2_Connector_6,0: The DB2 Load API call failed with SQLCODE -2,036. Load messages are stored in m...

Hi Michael,

Thanks for the clarification on 'exception table is to capture unique key violations'
How to get the error code in the exception table(Foreign key viloation, unique key violation)
Could you please explain how to create the dump file and also how to get the error code for the same

Sorry.. Put in the wrong category. changing to parallel

Hi Eric,
Thanks for the post.
Will check the option with the IBM support team

Hi, Stuck with bulk load features in DB2 Connector stage. After multiple errors left with queries. Below I am trying to explain my problem with maximum details. Your expert help needed resolve the problem Using bulk load facility to load massive data for faster load and to avoid creating of archive ...