DSXchange

HI Craig,
My target is ORacle, one more thing, I get a warning for the rows which are rejected to sequential file, and this record is loaded in the sequential file which is my reject link. I was wondering how to make these warnings disappear.
Thanks
Jamy

Oh Boy, what a coincidence, right now I'm working on the same thing, I need to find out how to do this, I'm trying different stuff but nothing seems to work, Try this one: just check the checkboc Reject Row in the secondlink(or rejcet link) which has to be the last one and mention no constraint in t...

Thanks Guys, I tried that option but I still get warnings (but the records are loaded into both target and sequentila file) like this one, which I need to send to the sequential file which is my second output link. Transformer_0 (Timestamp) transform error: Invalid timestamp input '<Missing or NULL>...

HI All, This was probably asked before in here, but I couldn't find an appropriate one, so please help. I want to capture all the rows that have failed to be loaded into the Target Oracle DB because of any input error(like duplicates, non nulls, or any error which doesn't let the row to be loaded in...

This is the logic FINAL = if (DSLink3.ATTRIBUTE8 < "1990/09/30") then Oconv(Iconv("07/01/1990",'D/E'),'D DMY[,A,]') Else if ( "1990/09/30" < DSLink3.ATTRIBUTE8 > "09/30/1993" ) then (Oconv((MONTH.LAST(BETWEEN)+1),'D DMY[,A,]')) else @NULL and BETWEEN = Field(D...

This is my derivation.
here FINAL is a stage variable which computes to a date in the format "DD MONTH YYYY"
Oconv(Iconv(FINAL,'D/E'),'D YMD'): " " : Oconv(@TIME,'MTHS')

Same here Eric, I'm kinda new to DataStage, I so wanted a book which gives you a whole gist of DataStage, but nah I realised its not possible to wrap in one book, and started studying the Doc's of DataStage which ofcourse do take a hell lot of time, if you don't know where to start. anyway I started...

I'm Trying to Insert a value into an oracle table, my source is also oracle, but I'm performaing a logic, like changing the output date depending on the input date. anyway while doing this, I was getting ORA error "ORA- 1856: a non-numeric character found instead where a digit was expected"...

I wrote a simple nextquarter routine. it works fine.
Thank you for your suggestion Ray,
Vanam

Thanks Ray, I wasn't able to figure out one thing from doc's for Quarter.Last transform. it says the input will take Input date format in (YYYY-MM) but it doesn't work when I give this format of the input date. does it need a input in the Quater format like year and Quarter. and One More question ca...

Thanks Craig.
I'm sorry I forgot to mention I need the first day of the next full month or Quarter following the input date. I guess I'll have to write a new function

james

Hi,
I'm trying to find the first day of the full month following a date(which is the input value).
not able to find the functions, could somebody please help
Thank you
James

Thanks Kim and Duke appreciate your help. I'll have to talk to my team leader about using Data stage instead of the procedure.
Thanks Again

call GPADMIN.PKGGPI.LOG_PROCESS('process_name','LAST_EDIT_DATE','TO_CHAR(SYSDATE,'YYYY-MM-DD HH24:MI:SS') ','LAST_EDIT_USER')

I'm trying to use this in my after sql, and error message I get is
:Missing right paranthesis. no clue as to where i missed it.

Thanks in advance
James

Thanks craig, one more small thing I'm trying to figure out. one of the arguments in the stored Proc i'm calling needs current date like SYSDATE ,and the other three arguments i'm using from the columns of the target OCIstage(where i'm writing the stored proc) and a job parameter. basically what I'm...