DSXchange

Hi Friends,
I want to add/substract one day from a giveg Timestamp in PX. Can you please give some solution/suggestions how to achive this?


Thanks in Advance.

Regards,
Mattu

Hello DS Gurus, I am loading the data into an Oracle table. How can I call a Oracle sequence to increase the key column value through the Datastage job? Alternatively, Can I use the surrogate key generator to increase the key column value? What are the options need to set to achive this? Thanks in A...

Hi All, I want to ren the sequence of jobs depending upon the identifier. My job is reading from a oracle table and has many rows. Depending upon the group identifier in each record, I want to run that specific job and then for the next record......Upto end of all records.(one to one maping between ...

Hi,
I want to assign a stage variable value to a job parameter.

Can you please guide me how to assign the stage variable from a transformer stage to the job parameter or the last value of the stage variable to a Job parameter?

Thanks,
Mattu

Hi, When I am running my job, I am getting this warning. Although the records are populated correctly, still then there are lot of warnings like:- APT_CombinedOperatorController,0: Null string argument. and APT_CombinedOperatorController,0: Numeric string expected for returned value from function ca...

[Mattu]:-

Thanks a lot...This is working fine now......


Regards,
Mattu

Hi,
I am trying to read a string in a single column in sequential stage in pX which length is 500 characters. But while I am reading it is truncating and maximum 250 character is reading.

Please give some suggestions to avoid that problem.

Regards,
mattu

kumar_s wrote:I guess the field should be char/varchar/integer.
Just grep the month from the field. Link.Filed[4,2] and check whether it is greated than MonthFromDate(CurrentDate())-36

I am new to datastage and i dont have much knowledge abt the datastage ..can anyone plz explain me clearly what i have to do ...

If the source file is a text file, you'll have to read it all (because you can only get to the next byte in a text file by traversing the preceding bytes). Read it all into DataStage, then use a Filt ... The file is a sequential and i want some exclusion logic in transformer so that it meets the co...

Welcome Aboard :D You need to furnish more information. Do you have a date column. Or what is the format of the column based on which you like to retrive. Besides, you can use MonthFromDate function to retrive the current month. The file is a sequential and its one of the column name is Frist_servi...

hi ...
I want to get the latest 36 months of data from the source file ,the condition is that i have to use some exclusion logic for that .
So please any one of u know how to do that in data stage PX then plz get me know ...
Thanks in advance ...