DSXchange

Please help me to create and how to use the user defined DataStage functions on basses input columns and implementation if and else conditions .

My next step to map the out put to specified columns.

share your thoughts .

Thanks,
Vinod

You need to convert EBCDIC year/day/month fields to ASCII format. Try below option - Dtx( seq( DateColomn[1,1]),2) : "-": Dtx( seq( DateColomn[2,1]),2) : "-":Dtx( seq( DateColomn[3,1]),2) Thanks Vinod Hi, I am new to EBCDIC file format. I am reading EBCDIC file through Seq. file ...

Dear friends,

Please suggest- how to know the list of DataStage commands ,those are running in DS-Administrator Command prompt.

For example:

LIST READU -To know the list of pids with respect to datastage job name and other information

Thanks
Vinod

How to decalre user define.

i need result in column and return value in output parameter

Hi freinds, For Sever Routine - My problem is how to store return value in parameter and how to call value in output parameter I have store the value returning from simple SQL and calling output argument in server routine. Is possible with sql or I have to right the PLSQL code for the returning valu...

Hi friends,

Please suggest - How to know the PID from perticular job in DS-director.

This is reqiured for unlock the job.


Thanks
Vinod

Thanks oacvb!

Hi all,


Is thier any option in datastage to make the readble for pertucular job.

Thanks
Vinod

Hi freinds,

How to make the job only in read mode.

Only view the job and not save the changes

Thanks
Vinod

Dear friends,


How to insert the datastage Log-warnings into the oracle table.

Thanks
Vinod

Hi All,

I have to create the parallel routines for next day (Today+1Day)

Please any one can help me on how to create the routine.


Thanks
Vinod

Hi


I am planning to do certificate for datastage. Please give some tips and process for that.

Thanks
Vinod

Hi


I am planning to do certificate for datastage. Please give some tips and process for that.

Thanks
Vinod

Hi


I am planning to do certificate for datastage. Please give some tips and process for that.

Thanks
Vinod

Hi


I am planning to do certificate for datastage. Please give some tips and process for that.

Thanks
vinod

Hi


I am planning to do certificate for datastage. Please give some tips and process for that.

Thanks
man