DSXchange

Thanx Kirthi...got it...

Hi Nagdi, Thanks for the reply. I just confirmed, I have the fileds in ODBC stage. The problem is, i have to update based on a date range condition. I have two fields coming into the ODBC stage. 1. END_DATE.(END_DATE is one of the fields in the table) 2. AC_ID (One of the matching conditions for upd...

Hi, I have a requirement to update a set of records in a table which falls in a particular date range and matches a value in table. Each Record in the table has a start date and and End Date. Since there is a date range check involved in the update, i think I have to use a user defined query for upd...

Thanks Ray, for providing a simple solution.....

Hi Ray and Duke, Thanks for the reply. Ray, I need to take in all the records from source. I am just copying a sample data set and my expected output. Values Coming as parameter to the routine. Passed to the Routine through the parameter: UpdatedRec. This is the main input file to my Job 1,AA,TCC,Y,...

Hi, I am facing a problem with developing a routine for sequential file handling. When I call the the file handling routine from job, the job just hangs without reading records from source. I have this particulr routine, which reads a sequential file, searches for a string in it, there can be multip...

Hi All, Thanks for suggestions. All the jobs in the project create hashfiles in directory path on a seperate file system. I have 8 GB of space allocated for the specific file system. Each time when the jobs run, the file system gets full abnormally...and i'm processing GBs of data. From your answers...

Hi, In our development environment, the File System on which DataStage is installed is getting full. Currently we are doing some testing and other developement on the server. All our intermediate files are created in a seperate file system. I am unable to find out the reason for this. Searched in th...

DB2 Connect is configured on the server. I was trying with ODBC stage. But could find that DB2 Stage works fine and connects to the mainframe DB. So proceeded with that approach than ODBC stage.

Thanks,
Sasi

Hi, I am trying to connect to DB2 on mainframe from DS but it's giving the error. I am able to connect to the DB2 Db on mainfram from DS server on Unix. But when I try to connect from DS I am getting the following Error: BCI Error: SQLSTATE=08S01,CODE=0,[DataStage][SQL Client][ODBC][DataDirect][ODBC...

Hi Arnd,
Thanks for the reply. Yes, I tried the same with dsdsm user and it's working fine...is it possible for me to enable other users to execute dsjob. Does it require only read permission on the file for other users or any other changes required....

Pls advice...


Thanks,
Sasi.

Hi Ray,
I want to execute a function in DB if in input rows meet some conditions and get the return value from the function. Of course I can make use of shell scripts but it may not be the best method....

Hi, I am trying to execute dsjob from DSHOME/bin directory, but iam getting the following error exec(): 0509-036 Cannot load program dsjob because of the following errors: 0509-150 Dependent module libvmdsapi.so could not be loaded. 0509-022 Cannot load module libvmdsapi.so. 0509-026 System error: A...

Hi,
I would like to know, how I can connect to a DB and execute sql statements, from a datastage routine written in basic. Any input in this will be very helpful.

Thanks,
Sasi

Hi Guru,

Thanks for the reply.

I have not implemented any DELETE statement in the target ODBC Stage , I m just loading data with update action as CLEAR THE TABLE, THEN INSERT DATA.

And my job getting aborted when the table has data already.

Cheers
Sasi