DSXchange

Is it possible to post the C++ code you have created. I guess you have selected the Object type as Library. Since you have created a object file select the object as the option. long BinaryToDecimal(const char * pstrBinary) { int intLoop=0; long lngReturn=0L; long lngMultip=1L; for (intLoop=0; intL...

Thanks a lot Kumar.
I did exactly the same as you have mentioned but geting some run time error which I have already posted in one more Topic "Parallel Routine"

I would really appreciate anyinput on this too.

Cheers
OP

Hi, I have a C function (BinaryToDecimal()) which converts binary input into Decimal. As we are working on AIX , we created the object file by using Visual Age C++ default compiler by the following command: xlc -c binarytodecimal.c -o binarytodecimal.o Then using the object file binarytodecimal.o in...

Hi
As I'm new to datastage I dont know how to write a parallel routine . I tried serching the forum but couldnt get right result.
Can anybody send me correct link to the subject or guide me writting one.

Cheers
Om

Hi,
How can I convert decimal input to hexadecimal characters in a Parallel job?
Any help is appreciated.

Cheers
OP

Yes, Thats what I'm doing now generating two new columns in the transformer stage for current date - 1 day and converting timestamp to date in another and comparing it in filterstage. OR I can filter it inside the transformer it self and I dont need a filter stage. But what I thought was Filter stag...

Hi, I have used the below code in the "Where Clause" TimestampToDate(Process_timestamp)=DateFromJulianDay(JulianDayFromDate(CurrentDate())-1) When run geting the below Fatel error: Filter_36: Parse error: Expected comparison, 'between', or 'like' operator, got: "(" Parse error: E...

Its the syntax ,
Can I use the function used in transformer in where clause of filter stage?

Hi I have a requirement where I need to filter incoming data based on Date i.e there is a column Process_timestamp(data type: Time stamp), I need records where Date(Process_timestamp)=current date - 1 day What would be the syntax in the where clause in filter stage Any help is appreciated. Regards O...

Hi All,

How to achieve the same thing in Oracle Enterprise Stage??

Brad,
That was great..,it helped me fetching data 4 times as fast.
I would like to add here that you also can use :
in place of
it works better with DB2v8

Try using timestamo to char function in DB2 in the sql ......

Try clearing the log...

You can try using "Filter Stage" A newbie. 1st hands-on week..need some help.. In this scenario, which is the 'ideal/best' stage ?? Thanx, V I have input Charge records in this sequence, Rec1: AAAAAA $100 01 02 03 04 Rec2: BBBBBB $150 01 04 07 Rec3: CCCCCC $120 01 03 04 07 and I need to cr...

Assuming that your target table is DB2, and you are mapping UPDATE_TIMESTAMP as current Date() in transformer, its Datastage which converts the timestamp into DB2's readable format.When you view the data , it shows the data in the format you ave mentioned. So when you fire a select querry on the con...