DSXchange

How do i use IConv and OCONV to check this and convert into correct format.

Thanks

sheema

My source is a sequential file,where in i have a column which is of type varchar and length is 8.I need to check whether this column is a date in the format YYYYMMDD.If it is not in that format i need to replace a Null.

Do we have any function to check this.


Thanks
sheema

I am sorry,it missed that part.
It is working fine now.
Thanks for the needy help.


Sheema

Hi Chulett, I have changed as you suggested the datatype for target date as timestamp 19 used OCONV(ICONV(Date,"D/MDY[2,2,4]"),"D-YMD[4,2,2]"):" 00:00:00". I have used user defined Sql, where i am not doing any conversion. I am getting error ORA-00936: missing expressio...

My source is coming as mm/dd/yyyy which is varchar , now they say that the target is a oracle table and it has to be converted into date. so in the transformer i am using OCONV(ICONV(Date,"D/MDY[2,2,4]"),"D-DMY[2,A3,2]"). In the ORAOCI stage i am using a user defined sql and i am...

Hi , I have a job where in my source is sequential file and target is OraOCI. in my seq file the data type for date field is varchar,i need to convert this into timestamp and than just take the date part of it(first 10 characters). I have selected the datatype Timestamp for OraOCI.I have used Genera...

I have imported some jobs from 6.0.1.5 to 7.5.In one of the jobs,I have a ORAOCI stage as lookup and i am using a fully generated qury for that. But still i am getting the error ORA-01008: not all variables bound. when i have done a search on this error ,i have seen that there is a patch. I tried to...

I have a server job,where in i have a ORAOCI stage and a store procedure stage.I pass values 3 input values from ORAOCI stage to STP stage.The stored procedure stage is supposed to return a value ,but it is not returning a value.I have executed the Stored procedure with the same input values in TOAD...

I have a server job,where in i have a ORAOCI stage,a transformer and a ORAOCI stage as lookup.My requirement is that i need to call a stored procedure in the ORAOCI stage(lookup),this procedure takes 3 input values and returns a output value.These input values have to be selected from the oracle dat...

I am using Datastage 7.5 server edition.In the STP stage i do not have Syntax, Parameters and Error Codes instead i just have all of these in the properties tab.so there is no way that i can map my parameters.I saw that you have faced the same problem. Can you let me know,How you solved this problem.

when i right click on the Stored Procedure stage,i am getting an option
Grid when i click on that option,i am getting the same properties which i am getting in the properties option.

How should i deselct the Grid style.

The stored procedure stage properties are getting displayed in the grid style.what i mean to say is Usually we should have General tab,syntax tab,parameters tab and the Error Codes tab in the main Stage Tab.But i have the General tab and the Properties tab (in Stage tab)and in the properties tab i h...

I have tested the sequence through Routine Activity and it is working .
Thanks alot Kris.

Kris,
Yes,I meant to say that my server is on Unix and client is installed on Windows.Sorry if i have confused you.Thanks for the detailed explanation.
I will follow the process which you mentioned in last post and let you know how it works.

Thanks Kris,I want to try on a windows machine with a Routine Activity stage that executes the script via the DSExecute function.

Can you tell me step wise,i have not used Routine Activity or DSExecute function earrlier.