DSXchange

hi, I am generating a report for job by describing about the stages in the description tab but the problem is i can't see that description for source and target stages in report where as i am able to see for processing stages.please advise me on this one. How can i see for source or target stages de...

hi,

i have design one job running fine in dev environment but failed in qa .Its simple extraction from source to target.what i have to check for this kind of situation to fix this issue.Please help me on this

hi chulett, there are no warnings in log.......in trigger i give the condition s like if job execute ok then its goes to the next job activity otherwise it send the email and terminate the job. all the jobs running individually fine ....the job sequence run fine first and after second run only first...

hi, i have design sequence job with 5 jobs in job activity .when i run the job it only runs the first job and finished after that.I didn't understand why the other jobs are not running. i check each job individually and run it but in sequence only first job is running other s are not running. i have...

thanks all .......

hi chulett

i want to use the header and trailer in sequence job if it fails it send email to sequencer and job abort.

hi sura,

can you tell me what kind of logic i have to use in stage varaiables.Can you send me some kind of coding so that i can use that one.

hi, My job design is seq file..........>xfm............>seq file(header) ...............>seq file(trailer) i have comma delimiter seq file and file have header ,detail and trailer records.I want to validate header and trailer. Can you please advice me how can i do header and trailer validation. i sp...

i am getting the followinfg error SQLSTATE=23000, DBMS.CODE=2627 [DataStage][SQL Client][ODBC][IBM (DataDirect OEM) ][ODBC SQL Server Driver][SQL Server]Violation of PRIMARY KEY constraint 'PK__TBL_SRC_PARIS_EX__49A4C67D'. Cannot insert duplicate key in object 'TBL_SRC_PARIS_EXTRACT'. SQLSTATE=01000...

hi chulett,

can you please send me the tranformation code.

in seg file Column RPT_DT having datatype char ,length(23,3)and in target is datetime.

The tranformtion code i am using is
timestamp(iconv(trim(RPT)," D/2"))

can you please advice me on this

hi, i am getting the following error. SQL statement:INSERT INTO TBL_SRC_PARIS_EXTRACT(RPT_DT, CHILD_FUND_ID, CHILD_FUND_CATG, CHILD_FUND_SHRT_NM, SERIES_ID, SERIES_CATG, SERIES_TYP, PARENT_FUND_ID, PARENT_FUND_CATG, ACCT_INVST, AI_CNTR_TYP, PARIS_CNTR_NUM, PARIS_CNTR_NAME, PARIS_BUS_MRKT, END_OF_PR_...

hi i m getting the following error AAC_PARIS_TST..ODBC_37: DSD.BCIConnect connecting to AAC, call to SQLConnect failed. SQLSTATE=28000, DBMS.CODE=18456 [DataStage][SQL Client][ODBC][IBM (DataDirect OEM) ][ODBC SQL Server Driver][SQL Server]Login failed for user 'sql_u my job design is seq file.........

hi sura,

the datatype and length in sequential file is same as that of target ODBC(sql server)

i can view in seqentail file but couldn't be able to insert to target ODBS

yes chullett

this is server job

my error is this.

SQLSTATE=01004, DBMS.CODE=0
[DataStage][SQL Client]Data has been truncated
SQLSTATE=22005, DBMS.CODE=0
[DataStage][SQL Client][ODBC][IBM (DataDirect OEM) ][ODBC SQL Server Driver]Invalid character value for cast specification

This one i coming from target ODBC(SQL server)