DSXchange

hi

can you tell me how did you find the count of rows in the sequential file.

thanks in advance
rachitha.

hi

Convert your source column into "dd-mon-yy" i.e for ex : "24-NOV-06" format and try.Am not sure whether it works but give a try.

Thank You,
Rachitha.

Hi

Prasad ,,, are you sure that you have data in your hash file..
if not .. first create that hash file and load data into it with the help of any seq file or ODBC stage. then use this hash file in "utilityhashlookup " routine.

Thanks,
Rachitha.

ray.wurlod wrote:... but the count will be given in the status bar. ...

SELECT MAX(JOBNO) FROM DS_JOBS .

execute this query DS Admin command

Thanks
Rachitha

Hi All, I have hash file as input to a transformer and two outputs( one for target table and one for target error table) In transformer I gave constraints as link1.rejected for the error table link1 is output to target table I am not getting the rejected row in error table but a warning which says ...

We are reading Messages from a queue on diferent MQ server to etl server using MQ stage. But it appears whenever I do a destructive read the channel sender located on MQ server goes down. is this a normal behaviour ? Does anyone experienced this before ? Thanks hi.. i dn't know answer for your quer...

Hi all We need to create a Dtastage job to get the job statistics from the job log created in Datastage. 1) How many source records 2) How many rejected - rejects can be in lookups, due to source metadata, error cnditions etc. 3) How many loaded/updated Can anybody help me please.... Thanks chk out...

hi

i want to learn writing routines in datastage.. can any one of you guide me .. plz suggest any websites or books.waiting for your reply.

thanks in advance
rachitha

ray.wurlod wrote:Depending on the stage type you can also get LASTERR as well as DBMSCODE (these are output link variables from the link attempting to put the row into the target database). Capture these onto a separ ...

Can you plz be much more clear.

Thank You
rachitha.

The easiest method is to capture those rejected records with their warning messages from the job itself and write them to a sequential file. This can then be used for error tracking. It is much easier to implement and maintain than a separate job that extracts warning messages from log files and th...

Hi.. First of all i would like to say that am new to datastage i dn't know much abt this. i have just done one simple datamart. If we think from end user side, for ex : assume a report contains some rejected records too... and the enduser must know why those records have been rejected. We can implem...

if we run job.. some records may be rejected. i want to fetch the reason for its rejection at datastage level. you can say that we can do it manually of course.. but i want it to be done automatically by the datastage using some dsgetlogsummary macro's. so plz gimme suggestions.

Hi..

I want to retrieve warning messages at runtime and assign the reason for rejection to appropriate record key . Waititng for your suggestions.

Thanks In Advance ,
Rachitha.

hi.. take odbc lookup , in that specify start and end dates as keys and select userdefined query. go to view query there you change "start_date< ? and end_date> ?" just you have to change "=" to < and > as i have mentioned in double quotes. then in transformer give link from 1) s...