DSXchange

The workaround from the link worked - http://www-01.ibm.com/support/docview.w ... wg1JR32621

ray.wurlod wrote:The PAT file is not missing and is intact. The problem is with the input text override file APPCLIB/USMNAD.ITO - or maybe that the subdirectory APPCLIB does not exist. ...

[/quote]

There is no such directory as APPCLIB any where. Could you please give me more details.

ray.wurlod wrote:The PAT file is not missing and is intact. The problem is with the input text override file APPCLIB/USMNAD.ITO - or maybe that the subdirectory APPCLIB does not exist. ...

How can I recreate .PAT file? Provision does not seem to recreate it. The error I get while using MNS stage to get ISO contry code is MNS_398,0: Convert table not found MNS_398,0: Error occurred on line 8620 of file /IBM/InformationServer/Server/PXEngine/bin/Apps/MNV/Controls/COUNTRY/US/USMNAD.PAT P...

I switched the ODBC stage to Dynamic RDBMS stage and loaded all the 60K data. Thanks!

How do i define LongVarChar field as unbounded. If i do not specify any length in ODBC stage to load into DB2 CLOB, the fatal error is "APT_CombinedOperatorController,0: Fatal Error: Not bounded length." If i specify the length as 60000 or so, the job finished successfully, but only about ...

The job failed when i randomly specified as 60000 for lenght in LongVarChar. Error 'APT_CombinedOperatorController,0: Fatal Error: Not bounded length.' node_node1: ?? (13; SOL_SOCKET, SO_ERROR; 57; Socket operation on non-socket) ?? (15; SOL_SOCKET, SO_ERROR; 57; Socket operation on non-socket) You ...

Hi, I have a requirement to load a huge text field (60K) in a text file into a DB2 CLOB field. I specified the fields in ODBC stage as LongVarChar. The job fails if i specify the LongVarChar lenght to be 60000. It accepts only 30000 as length. How can i handle 60K CLOB load.

Oops, found the solution. I should set 'AccountNum' as Key and not 'UserID'. It works

Hi, Input to XML Output stage is --------------------------------- randy6666,000001 Henry12345,000002 Henry12345,000003 Jill7890,000004 Jill7890,000005 Jill7890,000006 XMap defined ------------- /Request/@ID /Request/@Version /Request/Action/text() /Request/Parameters/Users/UserID/@ID (ser this as p...

IBM documentation pdf had the same explanation for all three ZQMIXNZQ, ZQMIXAZQ, ZQMIXRZQ separators used in Standardize stage, Can anyone tell me the diff - When to use what. I have a requirement to cleanse US address. Some addresses are 4 lines, some are 5 lines and they have all sorts of possible...

Unix script works fine for this requirement. Thanks for the quick repsonse!

Hi my requirement is to split a varaible lenght record into fixed lenght records. What stage can accomplish this? Input Key,Col1,Col2,Col3,......... (can go up to 700 variable columns) 123,100001,100002,100003,100004 223,200001,200002,200003 323,300001,300002,300003,300004,300005 Desired output Key,...

I am using USPREP rule set with literal ZQMIZNZQ and i get the error 'Non-negative numeric operand expected' on the standardize stage.

Did anyone find the solution?

What should be the override pattern for the below addresses Is there a way i can overide to force 'ATTN: POSTMASTER' to Additional Address column, no matter what the input pattern is. There are about 100+ diff input/unhandled patterns starting with 'ATTN: POSTMASTER' Address (Input Pattern) --------...

Issue resolved!

chulett wrote:

reachsam11 wrote:BTW, the version is 8.0

BTW - update, update, update!