DSXchange

Hi All, i tried using date_from_string function in Modify stage: My o/p column is date datatype in oracle db. In modify stage i used new filed DT DT:date=date_from_string("2013-04-04","yyyy-mm-dd") I'm getting this below error: main_program: Error parsing modify adapter: Error in...

Hi All, when i used CurrentTimestampMS() in my transformer i'm getting the date as "2013-04-16 07:46:40.626082" means the format is "YYYY-MM-DD HH:MM:SS.NNNNNN" But I wanted the format to be in "CCYY-MM-DD-HH.MM.SS.NNNNNN' Could you please let me know How to do achive this i...

i have a requirement where for column1 i need to right pad with spaces and column2 left pad with spaces in 8.1 parallel jobs.
unable to find rpad and lpad functions in transformer.

I need a string not a date

I've a varchar field with value 8/8/2012 now I want to convert it to 08-08-2012. when i'm trying to convert it to date using string to date function i'm not able to view the data.please provide me the logic to achieve the above..thanks in advance

SURA wrote:Fine you can sort the data in desc and use stage variable in the TFM

can you please give tell me how to use the stage variable in the transformer

Input: employee_id, salary ------------------- 10, 1000 20, 2000 30, 3000 40, 5000 output: employee_id, salary, next_row_salary ------------------------------------ 10, 1000, 2000 20, 2000, 3000 30, 3000, 5000 40, 5000, Null I need a Datastage job to get this output.

Hi All, I'm new to DS PX. Could you please suggest me the design for this scenario. I'm having huge records so wanted to build the job thinking about the performance also. SQL Query: SELECT * FROM ABC WHERE (aaa,bbb,ccc) IN ( SELECT aaa,bbb,ccc FROM ABC WHERE STATUS = 'CLOSE' AND FLAG='Y' AND TRUNC(...

Hi All, Need help to prepare job design for the below SQL query operation. I cant use this query directly in Oracle Stage as the tables ABC and DEF are from different databases. Please help me in how to develop the job for the same. SELECT * FROM ABC WHERE (xxx,yyy,zzz) IN ( SELECT xxx,yyy,zzz FROM ...

Hi All, Since I'm new to Datastage unable to prepare design for the below one. Please help me: For Query1 and Query2 I'm not sure how to design the parallel job. Query1: SELECT * FROM ABC WHERE XXX IN (SELECT XXX FROM ABC where STAT = 'CLOSE' AND FLAG = 0 AND TRUNC((sysDate-CURRENTDATE) / 365) >= 2 ...

Thanks for the above query. I will check on this.

I tried using TimestamptoDate function in transformer for the date columns then the job worked fine.

Hi All,
I am performing direct loading of data from table to table. Same table name and same structure used in two different schemas.
Still I'm getting the below error:
Fatal Error: Invalid Julian day

How to resolve this issue.

Design:
ORA stage to COPY stage to ORA stage.

Thanks in Advance,

suse_dk wrote:We map the CLOB datatype to NVARCHAR(MAX) (on SQL server 2008 R2)

In parallel job I'm using Oracle stage. so how to handle it

Thanks in Advance,

Hi All, I'm using CLOB datatype column in my Parallel Job and my job is getting aborted with the below errors: main_program: Unsupported SQL type CLOB or NCLOB for column MSG. main_program: Fatal Error: Caught ORCHESTRATE exception in main program: APT_ParseError: Could not find type: generic I'm fe...

Hi, Currently I have a macro which is written in VB script in excel sheet. This macro will caluculate the date fields and generate two excel sheets as output. These two excel sheets I have to used as input to another datastage job. I want to use this macro within datastage job. Can you please let me...