DSXchange

Hi everybody! I have a main job sequence that call all my data load process. That main job sequence has some parameters, and the value of these parameters are in a file. I need to read this file and call my main job sequence sending the parameters. I was thinking make this using a job batch! Does an...

ray.wurlod wrote: Why are you surprised? ...

Because it is the first time that I have SQL Server as a source.

Fernando

Thanks!

Hi! My source is SQL Server! I need to work with a result set from a SQL Server's stored procedure in DataStage and after input the data into a Oracle. Is there any stage that work with a stored procedure result set? In the version 7.5 there is a "stored procedure stage" that work with Ora...

Thank you!

Work very well!

Regards,

Fernando

Sorry but I don't understand "floor"

Thanks
Fernando

Hi! I'm transforming a Server job to Parallel Job and I have the following command Oconv(Trim(LINK_004.OTHER_AMT),'MD2') that work in a transformer stage and it doesn't work in a parallel job. I saw that there is a function -> StringtoDecimal(String,Rtype) but the help that I have is very poor. Can ...

Sorry ,

I'm working with 8 character.

Regards,

Fernando

ray.wurlod wrote:Are you really working with a nine character string here? If you are using a five digit year, then the substring extractions will need to be changed. ...

Thank you every body, but I preferred to make a server routine. It is in a version 1.0 but work in some cases. :roll: Follow the code. DD=Data[8, 2] MM=Data[6, 2] AA=Data[2, 4] RETORNO=Data[1, 9] If (DD > 0 AND DD < 32) AND (MM > 0 AND MM < 13) AND AA > 1 Then RETORNO=RETORNO Else RETORNO="0000...

Hi!

My imput in Transformer is '20060413', this is a date in the format(YYYYMMDD). But in some cases I receive '00000001' that is a invalid date.

Well, I would like to make a server routine that when receive the imput check if is a valid or invalid date.

Regards,

Fernando Martins

Thank you!

I have a date(YYYYMMDD) in a number format.

For example:
- 20050810 become 50810
- 20150810 become 150810

I have to insert this number in a oracle table where the field is a date.

I'm using Iconv(DATE, "DYMD[2,2,2]") but doesn't working.

Does anybody help me?

Regards,

Fernando

In the combo-box "Update Action" from Oracle 9 Stage there is the following action: -> Update existing rows or insert new rows Would I like to know if this action update the row independently if there was any change or if it update only the rows that changed something? Regards, Fernando

I need to calculate the difference between two dates in the transformer stage. x = end_date - start_date But there is some considerations: - I need the difference in days For example: x = 2005-05-12 - 2005-30-12 then x = 25 - the end_date is 'YYYY-MM-DD' For example: 2005-05-12 - the start_date is '...

Thank you and I would like to take a training but I don't have time, I'm in the midle of the project and if I ask to take a training my manager will say to me "bye bye friend!".
I'm not the one in Mainframe Jobs but with your help I hope to make these jobs.

Best Regards
Fernando