DSXchange

1) Use below derivation in Stage Variable "RESVAL" Trim( NullToEmpty(Input.AccName1) : '|' : NullToEmpty(Input.AccName2) : '|' : NullToEmpty(Input.AccName3) : '|' : NullToEmpty(Input.AccName4) : '|' : NullToEmpty(Input.AccName5) : '|' : NullToEmpty(Input.AccName6) : '|' : NullToEmpty(Inpu...

Finally, to my knowledge, we have traced out the route cause for this issue. Which I mean to say, gone thru entire process of Process Meta Broker (Logs, Events), Listener (Logs, Runs), Run Import (Logs) and found in Process Meta Broker - Logs, all the DataStage Job Run events are not seen. The same ...

Thanks Ray for your reply,

I have saved back all table definitions to repository and ensured that linkage between table definitions and jobs are perfect by doing Usage Analysis in DS Managaer.

Issue Intro: I have installed MetaStage and MetaBrokers for DataStage 7 and configured files for MetaBrokers,Listener,RunImport successfully. Then designed three test jobs like JOB_EXT -- EMP table --> TMP.DS dataset JOB_STG -- TMP.DS dataset --> STG_EMP table JOB_LOD -- STG_EMP table --> TGT_EMP t...

Why can't you lookinto macho works driven by Chuck, Duke, Kenneth geants and get your work simplify. Otherwise it will take more time to implement the same in your way. All the best.

In otherwords, we would like to know your requirement in detail as you expected the resonse.

Hi , source is Oracle Error executing View Data command: ##E TOSH 000205 03:56:09(004) <main_program> PATH search failure: Then I tired setting these D:\Ascential\DataStage\PXEngine\install>sh $ ORACLE_HOME="D:/oracle/product/10.1.0/db_1" $ export ORACLE_HOME $ APT_ORCHHOME = "D:/Asce...

Thanks for your support ..
I rectified the problem ..
The issue was regarding NLS mapping at oracle...That was Arabic data ..was not able to insert ...I corrected the NLS setting ..
Now it is runnign fine

I checked the problem feild length it is 16
But Iam not able to use bytelen function it is not available
Iam using Servere jobs.
Please advice

Hi...the structure of rejuction table:-- Data_Record Varchar 4000 Sql_Error_Code Varchar 100 Load_Sys Varchar 100 Load_Table Varchar 100 Hi...but the problem occured in sqlcode generated after the record is rejected.... for this i take copy stage and remove the sqlcode from output then its working ...

Hi...the structure of rejuction table:--

Data_Record Varchar 4000
Sql_Error_Code Varchar 100
Load_Sys Varchar 100
Load_Table Varchar 100

Hi...the structure of rejuction table:--

Data_Record Varchar 4000
Sql_Error_Code Varchar 100
Load_Sys Varchar 100
Load_Table Varchar 100

Hi! I am working on PX job. The Source is Dataset and target is SQLServer. To populate target i am using ODBC Stage,While doing Rejection process i am Getting following error:-- XfmReject: Error when checking operator: Could not find input field "sqlcode" Can you please help me to come out...

This is not a bright option since i have 7,8 foriegn keys in my table.is there any option to reject the records that does not meet the foriegn key constraint?

To answer your question, I think it is a bad design that you have rows that violate foreign key constraints. Such rows should never have made it to the target. However, if you are handling late arriving dimensions, then there are special ways of handling it.[/quote] Could you help me with a special ...

For the upsert mode property, you can use "update only option" and give the insert statement. Also you can set the Output Reject Record to true and capture them from the reject link. Might work. Try it and let us know if it works. I tried this way,but the job is getting aborted with the s...