DSXchange

Hi, I get a following error running a parallel routine and is a new routine created on: IBM XL C/C++ for AIX, V11.1 (5724-X13) Version: 11.01.0000.0017 Failed to load the library "V0S3_Str_Transformer_3.o"; either the directory containing the library file is not on the library search path,...

Craig, Could you be more specific? There is no explicit on conversion from varchar to char when extracting fields from the Table into a file being used as input to the standardization stage. these are existing jobs.extract job is a server job output of which is given as input to quality stage job th...

I have a scent ion where I extract fields from a table in varchar and fed them as char input to quality stage standardization stages. standardization out is char. I getting the following error: When checking operator: When binding output interface field USName to out filed USName : Implicit conversi...

No, I haven't done any change to the rule set yet. I don't understand the overide option. Unless I add new rule for the override pattern in the rule set doesn't tit work?IS there any example to add new rule the rule set designer?Please let me know.Thank you...

I changed the input pattern using overide in USADDR.SET and added them to override summary? is this the correct way to make it work? after rerunning the job I do not see the address is handled correctly where as testing using USADDR.SEt gives me the correct result.

Ray,

I do not see any overides in 8.1.

1000 ROAD N: is adrress is working correctly using USADDR rule set in Standardization stage on DS 8.1 where as in DS 9.1 is giving unhandled address. Could any one please let me know how can be this be resolved in 9.1 HouseNumber 1000 StreetPrefixType ROAD Streetname N AddressType S StreetnameNYSIIS...

Hi,

I have a scenario where I need to convert records in the order

order no seq no

01 01
01 02
01 03

02 01
02 02
02 03

to

01 01
02 01
01 02
02 02
01 03
02 03


can any one please let me know how can we achieve this? Thanks

I do not see any difference between the environment except for the file path and the project. Server is same. File is also the same..File is Copied from dev path to the current path.

Ray, all the fields have length defined. The job was imported from dev environment. Everything is intact. Its strange. Its supposed to work in the current environment like in the dev. If I read fixed with file through a single column I can view the data. SInce there are a large number of columns rea...

Hi, Unable to initialize the importer."record_length=fixed" (no length given) and record field format is variable-length. The first variable-length field is "" Job works fine in DS9.1 dev env . For the same file in higher environment the fails with above error . Is this a file is...

qt_ky,

The director log stops with

main_program:
orchgeneral: loaded
orchsort: loaded
orchstats: loaded
No other error messages.

Ray,I didn't get what you are saying..

Has any one came across such scenario before? I'm able to view the dataset.

is it because of lock on the table? or is this an DS configuration issue?

I have a scenario to load data from dataset to an oracle. Load fails immediately without even attempting to read data set. The director log stops with main_program: without generating any error for failure. Can any one please let me know what could go wrong with the code or Datastage? Any input is r...

Hi , I have a scenario where I have records with same uniq key columns and different surrogate key(PK) When I tried to update one of the records for all fields using surrogate key, load rejects data with error code -1. Is this because records have same unique key. My understanding is the record that...