DSXchange

Hi Ray,

Thanks for your support and kindness.


Thanks
Rasi

Hi, The naming standard depends from project to project. However a generic standard for the table definitions could be like -ProjectName (Your Project Name) --StagingName (Staging Area 1, 2 etc) --- DataSource (Oracle, SQLServer, Hash, Sequential etc) -- TableName (Name should be your Database Table...

Hi Martin, I think you need to check your job. If the source and target has the same decimal type then it shouldn't be problem to process the data. Check whether precision and scale is correct in source and target. also check whether you are converting the source decimal type to sting in your tranfo...

Hi,

The reason is the first link is overwritten with the second. To solve this issue you need to break your job as creating two different file and then using the Merge Stage join those two files to one file to get 15 +15 = 30 Records.

Thanks
Rasi

Hi,

Open your Main Job Sequencer and simply drag and drop the other two job sequencer you want to add in. It will work.

Thanks
Rasi

Hi Ray, The routine has no problem it works fine. Even after changing the ErrorCode = 0 it still logs a reject record in the director. And after changing the ErrorCode to 1 it says Job aborted, in that all the valid records gets inserted into the target even if the reject record is in between valid ...

Hi Ray, Thanks for your reply. The following is the code I am using in the after routiune. Still it rejects the records and sends warning. And in the Input value I use DSJ.LINKROWCOUNT. Thanks Rasi $INCLUDE DSINCLUDE JOBCONTROL.H Reply = DSGetLinkInfo(DSJ.ME,DSJ.ME,DSJ.ME,InputArg) Begin Case Case R...

Hi Ray,

I Had Created a after stage routine and it has the ErrorCode=0. While I call this in the after stage routine i gave DSGetLINKINFO as an input value. But is not working. I don't know what should i give as input and how to SET DSGetLinkInfo to 0.

Thanks
Rasi

Hi Ray,

I sorted this problem by changing the Default NLS Time/Date to US-English in the Datastage Administrator Project.

Thanks
Rasi

Hi Ray,

The status returned value 2. The result is empty. I guess the problem is definitely with the month name. How to solve this.

Thanks
Rasi

Hi All, Right now I found a problem which is quite strange. I am using the IConv and Oconv function to convert string into internal date and output to timestamp field. The function i had written has this code. Arg1="16-MAY-97 Ans = OConv(IConv(Arg1,"D-DMY[,A3,2]"),"D-YMD[4,2,2]&q...

Hi Ray thanks for your reply. The rejects i was saying is the rejects from validation. When a rows gets validated and rejected. It has to logged into a reject table with its surrogate key. But also I want to stop my job even if one row gets rejects. But want to log all the rejected records. Is there...

Hi, I am reading a blob image from SQL Server 2000. This image file has English and Non-English characters in it. When I read the image and write it as file it works for English. But when it reads Non-English Characters and writes to file the file is empty. Any idea what is this issue. I am using Ic...

Hi Ray,

I want all the rejected records to be loaded into reject table and also abort the job when first error occours. Is there any way for that.

Thanks
Rasi

Hi,

Inside datastage when we set the constraint to reject rows after 1 records. It aborts the job immediately when this constraint violates for the 1st record.
I need to trap all the reject rows into a separate table. Is there any way to do so.

Thanks
Rasi