DSXchange

Thanks a lot..The problem is solved by using the conversion:-

DateToString(TimestampToDate(inLink.Col),'%yyyy-%mmm-%dd')

Actually I need this to populate in my Error message....


Thanks a lot once again... :D

Thanks a lot...for the solution.

Is there any function in PX which can handle this?

Regards,
Prasanta

My input data type is Timestamp. But I am not able to figure out which function should I use to get in 'YYYY-MON-DD' format.

Could you please help out in this?

Hi All,
Could anyone plese help me how to convert 'YYYY-MM-DD hh:nn:ss'(Timestamp) format to 'YYYY-MON-DD' in PX by using any pre-defined function?

Thanks in Advance.

Regards,
Prasanta

Thanks a lot to all.... The Patch provided by the Support provider solved the problem... :D

[quote="ArndW"]Try resetting the sequence and then looking at the entry titled "from previous run..." p.s. This is a volunteer site, so using the word [i]urgent [/i]in a post here usually results in getting a much slower response than normal, and many expert posters here might ev...

Hi, Requirement is to load 1000 file at a time using the Job sequence. But in each run, the sequence gets aborted after 128 complete iterations i.e. after completion of 128 cycles, when it runs the job for 192 cycle, this is the message in the director "Attempting to Cleanup after ABORT raised ...

Could you please give some guide lines how to Add months to a date in DataStage PX?

Thanks in Advance.

Regards,
Prasanta

Could you please give some guide lines how to Add months to a date in DataStage PX?

Thanks in Advance.

Regards,
Prasanta

[Prasanta]:- In Oracle table it si Number(13). I am importing the metadata from manager, and it is coming as Decimal(13). Still then the warnings are:- I) oesR_STAGE_D0275_25B: Column STG_25B_PK floating point decimal is not fully supported; adjusting the scale. and II) oesR_STAGE_D0275_26B: When ch...

Hi All, I am Reading the data from an Oracle9i table using Oracle enterprise stage using PX. In PX I have defined thedata type as BigInt(13). But while reading the fields from the table for attribute "STG_25B_PK (Number(13) in oracle table)", I am getting warnings like "Column STG_25B...

[quote="Nageshsunkoji"]Hi , What about next val function ? Just add a new column called SEQ_NUM in database column list and in the Oracle stage in place of '?' give the function nextval for SEQ_NUM. Try out.[/quote] [quote="Prasanta"]Hi , The next val is not working....For the ti...

Hi All, I am loading the data in to Oracle9i table using PX. But before loading, I want to retrieve the maximum value of the Sl_No (a sequence number) in to a stage variable and then want to use that value for further to get the next serial number for the incoming source recordas there are some prim...