DSXchange

Thanx for clearing that up. lesson learnt. I totally forgot about the &PH& and what it contains. i was talking in general i guess about hash file.

live and learn,
Siva.

Hi, I dont think CLEAR.FILE deletes any thing, it only clears the contents of the file i guess. With my limited knowledge on this topic But i checked the Basic manual here is what it says Use the CLEARFILE statement to delete all records in an open dictionary or data file. You cannot use this statem...

Do a search and you will definetly find some thing to get going.

Here is a good one. This should get you going.

Siva.

In a before job get the max surrogate key and write it to a hash file and write a routine to get the value in the hash file and assign that to a stage variable and increment that stage variable using your @OUTROWNUM.

Hope this helps.
Siva

Thanx Ray, ur True GURU
I didnt know it works like that till now.

Have a good one.

I closed and reopened my connection and it workd fine now. i did that before also, it did work that time. I have no clue.

Thanx guys for the replys.
Have a good one.

There's nothing in that, blank.

There's no shift in columns. columns are in the same position. only some columns are balnk in the second job.

Metadata is same, hash file name is same. and also giving the right path. data is visible in some of the columns i dont know what's happening with the other columns.

Thanx for the reply though.

Hi, I'm having probelm with hash file. I created a hash file in the a job and viewed the data, all the data fileds are populated and every thing looks fine. then i save the table definition and build one more job to use the hash file as a lookup when i viewed the data in this job in the data browser...

I'm totally with u guys.

Ok, so i have to write my own string functions to do all the manipulations. like in a regular c compiler i cannot use any of the library functions? It looks like you are trying to call the Transformer functions from a buildop code i thought they are functions that i can use. ok u mean to say i have ...

Thanx Vitali for the reply, I'm getting these error messages Error: The function "Len" must have a prototype. Error: The function "Left" must have a prototype. Error: The function "Left" must have a prototype. Error: The function "Left" must have a prototype. ...

Hi Every one, I'm trying to build a BuildOp stage to be used in paralle jobs. i have incoming data that is 150 character long i have to parse the record and send it to many fileds. i'm trying to use the macros to get the string length and substring. so far i'm not sucessful in doing that. I tried to...

Hi Ken, Is there any way you could send me a copy of it. i'm trying to do some of the thing what you have mentioned. Run multiple instances of a job in a batch job-control which is again invoked by a sequencer. we could get the start time, end time, link info, job status for every instance. we did t...