DSXchange

Well, the error it throws is "main_program: Missing field: event_id in the input dataset." db2EVTXREFups: When preparing operator: When binding partitioner interface: Could not find input field "event_id". main_program: One or more operators failed to prepare OK main_program: Cre...

Yes, when loaded to a dataset it is pretty faster. So, what options are available to tune this db2 stage? earlier, when the partion type was set to db2 the job got aborted throwing a fatal error which read "could not find the <Seq_Num> field. The insert statement calls the seq num generator tab...

Hi, A job uses db2 EE stage to insert new records with a sequence number generated in db2 database. The performance drops drastically to a hundred rows per second from as high as seventy thousand rows/sec until it reaches the target db2 stage. Prior to writing the data to the table, a lookup on the ...

Well, Recently I prefered handling it in the sql itself to query a database with 1 million records (and growing...)

The target field is a varchar field but yes! ....am using a user defined Insert statement and am not trimming there. So this should be it. Lemme try it out trimming in the query as well.
Thanks.

ya, its the oracle...and the peek stage shows trimmed fields.

Am using the Siebel database...

That's why am using the transformer stage in between where I specify the RHS column as a varchar. Am I missing something here?

The data type from the dataset is char, and the results are as expected.
The trim(string) and the len(trim(string) are the same.
The actual len(string) is 9 but the data that has gone into the table is Len(15).

I have a dataset ->column import stage-> oracle OCI stage.
I added the transfomer stage btween the col import and oci stage and tried performing the trim.
The datatype in table is varchar.

Hi, A dataset is created using the $APT_STRING_PADCHAr(0x20). when inserting to a table, the data gets inserted along with the space. Use of trim function has not so far helped to remove the space inspite of the data type in oracle being a varchar. Is there any other means of doing this? Pls let me ...

Thanks Ray.
The sequence job somehow ran successfully after the user defined environment vairable (INITBIN) for Quality stage was added to the project.

Hi , While calling a Quality stage job using the command execute stage in a sequencer, it gives a warning and fails. While using the telnet i am able to run the QS job successfully. I use the sh 2>&1 and pass its parameters. Its says reply=1 and at the end I see a "Op Failed osh (1)" A...

Well yes! the import column stage had generated the error.
I have just found out that I had missed out pulling one column from the dataset.

Thanks,

Guys, While writing to a dataset, the record datatype is set to binary and the field length is set to 748 to enable the quality stage to do the standardisation bit. Later I read the dataset which has now a bigger record length of 2580 bytes. while running the job, which performs a update or insert o...