DSXchange

i tried this still outputing null

OCONV(ICONV(Field(DSLink2.CreateDate,"",1,1),"D"),"D-DMY[2,3A,2] hh:mm:ss")

Hi -
I needed help converting a date format(mm/dd/yyyy hh:mm:ss)
into (dd-MON-YY hh:mm:ss)

i think i have the second part correct
OCONV( ICONV(DSLink2.CreateDate,"D4YMD") ,"D-DMY[2,3A,2] hh:mm:ss")

any help?

I dont understand so now I change the transformation to output the date as
dd-mon-yy and now i am getting this error

Attempt to convert String value "02-DEC-08" to Date type unsuccessful

THis is the sql in my oracle stage

INSERT INTO PROCESS_LOG (RowCount,DATASOURCEKEY,JOBID,JOBDATETIME,TABLENAME,CREATED) VALUES (:1,:2,:3,TO_DATE(:4, 'DD-MON-YY'),:5,TO_DATE(:6, 'DD-MON-YY'))

I had that column set to a varchar thoughout the datastage project
because when i set the datatype of Date to the jobdate column
i get this issue

Value treated as NULL
Attempt to convert String value " 00:00:00" to Date type unsuccessful

I tried that now i am getting this error
ORA-01861: literal does not match format string


the output string looks like this now
2008-12-02 00:00:00

I have a Table in Oracle with a column of datatype DATE In my datastage transformer I do a conversion on a date i pass in Oconv(Iconv(JOBDATE, "DMDY"), "D/MDY[2,2,4]") : " 00:00:00" which displays 12/02/2008 00:00:00 when i pass in 12/02/2008 however I am getting an ora...

aww I see.
Is there anyway dateadd functions in server jobs

Does anyone know why this will not compile am I missing something

DateFromDaysSince(DateGenericToOraOCIWithTime(JobStartTime),1)

Hi I am calling a dsjob through a process in C# on a server(calls the dsjob.exe. When it runs the datastage job a command window opens is there anyway to make a datastage job when running it through dsjob exe command windowless. People are closing my windows which does not matter to the datastage jo...

Can you give me a little more detail on how this is done.

So after my stored procedure i send a link to a transformer which will be done on each row however then in the transformer i send a link to the aggregator stage .

Where in this stage does it allow you to specify last row i dont see it?

i like that idea. I will try it

i like that idea. I will try it

one row is loaded into the job log
however then i load thousands of rows in an etl job then i would like to insert one row into the job complete after those rows are loaded
So i guess your saying i have to build a routine.

nope they having nothing to do with each other this is the flow basically job paramters set to a stored procudure (insert into a job log job started) then i have sequential file passed into a stored procedure last i insert a row stating job completed of if i have any rows rejected jobs completed wit...