DSXchange

Sorry I missed your 2nd question, we have used Append -> Write mode to insert all records. No record qualifies for update.

It's runtime error while trying to load data to DB2 table using DB2/UDB Enterprise stage.

Hi All, We are facing connectivity errors while using DB2/UDB Enterprise stage to connect from a parallel job as below, DB2_UDB_Enterprise_58,0: Error Idx = 1; DB2Driver Embedded SQL message: SQL30082N Security processing failed with reason "3" ("PASSWORD MISSING"). SQLSTATE=0800...

Yes, Reject criteria is ON in both the cases. When the job is run in 'Insert only' mode then 2 records are getting rejected as per job statistics, where 1000 records are supposed to be rejected.
Also not able to see these 2 records from unix, or view data.

Hi, We are facing a problem while testing reject criteria from target ODBC stage. Our job has a ODBC stage (used as Oracle target) and reject mode is on. It's rejecting the records properly when kept in 'Upsert' mode, but not rejecting any data to file when target is in 'Insert only' mode. Testdata ...

Hi All, We want to generate an XML file having format as below, <?xml version="1.0" encoding="UTF-8"?> <!DOCTYPE system "catalog.dtd"> <root> <catalog cid="@cid_1" member_id="&MEMBER_ID;" identifier="Company" description="Company&q...

Thanks Ray ! I have tried, it's working !

Hi, We have a requirement to generate xml o/p and replace special chars as below, & with & \ with " ' with &apos; > with > < with < " with " I have used a Basic transformer and Ereplace() function . But not able to handle apostrophe/single quote replacement through this. E...

Thanks for your suggestions ! I will try with basic transformer .

Hi All, There is a requirement to change the first char of every word into Uppercase. Say i/p test is : willilam smith O/p should be : William Smith No. of words in the input string may vary. Is there any easy way to do this ? other than extracting first char of each word separately ? Please suggest...

I am also having similar requirement , not able to get the solution. Job is aborting. Please let us know if you find any solution.

I tried from Data Stage , as well as from Unix. In either case it's not fetching values. Kept the SQL as, WHERE DEST in ('#DESTINATIONS#') and passed value as ABC','XYZ. It's running but not fetching any record. But view data is working. Then changed the SQL as, WHERE DEST in (#DESTINATIONS#) and pa...

It's a ODBC Enterprise stage used to fetch data from DB2 table.

The SQL has below where clause, FINAL_DEST_UN_COD IN (#AB_Parm.PORT_OF_DESTINATION#) I have passed value as \'USCMH\',\'HKHKG\' Job is aborting with below error : main_program: [DataDirect][ODBC DB2 Wire Protocol driver][UDB DB2 for OS/390 and z/OS]ILLEGAL SYMBOL \; VALID SYMBOLS ARE ( + - ? : CASE ...

Hi Craig,
I have tried passing \'XYZ\',\'ABCD\' and \'XYZ\'\,\'ABCD\', but none of these is working. Is there any other way to implement it ?

Thanks,
Ankita