DSXchange

sandy_thomas

Did any one try this, running 10g with DataStage 6.0.X.

Regards,
Sandy.

sandy_thomas

Does any one know whether they have started this or not? and what is the procedure if they have.

Reagrds,
Sandy

sandy_thomas

Ray,

Is ther any way to get the session ID or IP address for the last change. In our Env most of the datastage users are common user id's. If i can get the IP address i can map to the meachine.

thanks a lot.

sandy_thomas

Hi Every One, Happy Holidays. You all have a good one. Coming to the question. I'm reading a sequential file in basic. I just want to know whether it is possible to use any string functions on the record we read like COMPARE or STR or SUBSTRINGS? like OPENSEQ 'INPUTFILE' TO READFILE ELSE ABORT END S...

sandy_thomas

I did that and I'm unsucessful. if there is data it does what it was supposed to do. But the problem comes when there is no data for that particular site.

sandy_thomas

The requirement is like this. we have a hash file that is being shared by many jobs. It has information of all the web sites that the corporation track. This hash file is used as a reference further in the jobs. At any given time the hash file has the most recent information that's being processed f...

sandy_thomas

if i get a key match then i have to go to that particular record and update the fields following the key field in the record.
i dont understand the use of "KEY" in your code.

Thanx for all the help though. i never wrote a routine for File I/O.

sandy_thomas

Code: Select all

OPENPATH '/open/devel/work/hash' to f.infile 
ELSE ABORT
QUIT=@FALSE
Loop
  read RCD from f.infile else QUIT=@TRUE
  UNTIL QUIT DO
   FileName = RCD[1,20]
   IF(FileName = InputArg )
      THEN RCD[21]=0 RCD[22] = 0
      QUIT=@True      
REPEAT
ErrorCode = 0

I'm in the root directory.

sandy_thomas

I'm trying to write a server routine. in that i have to open a hash file which has like 6 columns. The key column is "NAME", Based on the input argument( Which is "NAME") i have to go to that perticular record in the hash file and update the other fields. i'm trying to open the h...

DSXchange

Search found 9 matches

Ray is there any way to get the session ID for that change .

Reading a sequential file in Basic.

Hash File open/read/update in the server routine