DSXchange

The db2nodes dataset is in the sqllib directory. Check your db2 path. The file will have the node, host, and partition number. The host, has to exactly match your specifications of fastname. Some files have more that one name specified and that's okay, as long qs you have a fastname matching that s...

Hi, Usually im using odbc as a database in server job. Due to my data is very high (11 millions data) then i'm changing the odbc by using informix CLI(source) and target would be Informix Load (target) but Im getting this warning while i'm validating my job all the time. This is the error i get : Te...

Sorry.....updated into parallel

thanx

Hi, I'm using the server edition to do the parallel job. but when i using the informix (source) pointing directly into another informix (target) but when i checkout the source to view data. It gives me some errors like this : ##I TFCN 000001 14:40:45(000) <main_program> DataStage XE Parallel Extende...

Performing any arithmetic operation in a DataStage BASIC expression, such as adding zero to the number, will strip non-significant l ... Hi, Eventhough i cant see half of ur explaination....i forgot the trim function. I'm now using the trim(xxx,0,'L') but still thinking of the field data which is 0...

Performing any arithmetic operation in a DataStage BASIC expression, such as adding zero to the number, will strip non-significant l ... Hi, Eventhough i cant see half of ur explaination....i forgot the trim function. I'm now using the trim(xxx,0,'L') but still thinking of the field data which is 0...

Hi all, i have a list of data which is look like that -> 07:30 ,12:30,09:30 what i have to do is i have to extract the data from 07:30 -> 07 , 12:30 -> 12, 09:30 ->09 I used the Oconv(data field name , "G:1") then i can get the 07,12,09 But i dunno how to make it from 07 -> 7 ,12 ->12 , 09...

If it is character trim should work. Else If your field length is 2, then try If (A.code= "C ") Then "THis C" Else If (A.code= "P ") Then "This is P" Else "This is CP" Space after "C " and "P " ... Yes, It is a trim issue....than...

Hi all, I encountered a very strange problem. When i write this logic If (A.code= "C") Then "THis C" Else If (A.code= "P") Then "This is P" Else "This is CP" but the answer for my data are all "This is CP" but this is not suppose to have be...

Hi, I have stuck at here with few hours and my problem is.... i have 2 fields which is optional attribute which mean the data can be null characters. attribute name attribute data type attribute mandatory/optional A char(3) optional B char(3) optional The business rules is "either A OR B is man...

Ok... what mechanism are you using for getting the next value from the "table serial" and how is it being incremented? Any decent mechanism would support concurrency and it wouldn't be an issue for multiple processes to access it simultaneously without pulling the same key. For example, t...

Thanx for everyone replies... in table serial, it has 2 fields which are table name :ABC and curr_num =12345 . The curr num is the lates number whereby it use to put it in the the record before insert into target database. For example there are 2 records going in the target db, 1st record - primary ...

If you read in the Parallel Job Developer's Guide about surrogate key management you will get some ideas. You need, perhaps, to allocate separate ranges of serial numbers that can be used by each ins ... I'm sorry i cannot able to see whole of ur advice...but im using server edition. can i use the ...

I have a project which is doing in the multiple instance. When i get deep into it, i found out that i'm having on table serial issue. According my table serial in the project is generate primary key to the records before insert. All the records are referring the same table serial. IF it is running o...

avidal18 wrote:Thank you very much Ray, i find it.

Regards.

Angel.

Is is avidal18's question is is called batch commit?