DSXchange

Hi! I did encounter the same problem while loading 37million rows on to a table. The job was executing successfully previously but started failing one day and gave the same error with multiple trials. The table had one of its column as varchar 8 we changed it to char 8 in dataset and table definitio...

Hi! I am using a sequential stage with schema file to read ebcdic data from file The schema structure is_ as below record {record_format={type=implicit}, delim=none, quote=none, binary, ebcdic, native_endian, round=round_inf, fix_zero} ( BAL_FIELD:nullable decimal[3,0] {default='NULL',zoned}; .........

Hi! I am using a sequential stage with schema file to read ebcdic data from file The schema structure is_ as below record {record_format={type=implicit}, delim=none, quote=none, binary, ebcdic, native_endian, round=round_inf, fix_zero} ( BAL_FIELD:nullable decimal[3,0] {default='NULL',zoned}; .........

In one of my jobs I am doing a lookup against a large dataset The partitioning used at both ends (reference and main) are hash on same keys. It has been working fine so far, but wanted to know if this is a risk? I know that entire partitioning is recommended for reference link but our dataset being ...

I did right click on the warning message and added it to a message handler, after which I tried running the job again.

Still getting those warnings.

Wanted to know how to incorporate that message handler in the job/sequencer? What do i need to do for that?

I did right click on the warning message and added it to a message handler, after which I tried running the job again.

Still getting those warnings.

Wanted to know how to incorporate that message handler in the job/sequencer? What do i need to do for that?

Problem Description: ------------------------ no warnings on DS 7.5 but warnings produced on DS 7.5.3 while using the same code Warning: APT_CombinedOperatorController,1: Conversion error calling conversion routine date_from_string data may have been lost Transformation used to convert DECIMAL(8,0) ...

Hi All, I have a generic extract job which uses RCP with the following design seq_stage ---> filter_stage --> data_set The seq_stage reads an ebcdic file using schema file The problem with this job design is that even when the file is invalid (not in expected format as specified in schema file) the ...

Thanks Ray for the prompt reply. As I have mentioned my source is an ebcdic file. In ebcdic representation integer is internally stored as binary and decimal is internally stored in packed decimal format. since i am reading them using Complex flat file, i read this source field as decimal and cannot...

Hi, I am facing the following problem in data transformation The source is an ebcdic file, 1. source column details: column name : AB_CD column attribute : Decimal(1,0) column value : 1 2. Transformation details: straight mapping even tried DecimalToString(AB_CD) 3. target column details: column nam...

Job Description: The job uses 3 input files say 4 GB each being joined using a Join stage and then transformation applied before they are split into multiple output datasets. I am using a 4-node config file. (4 CPU) I plan to execute as large as 6 such jobs in parallell, what would be the scratch sp...