DSXchange

ora_Sample_load,1: Operator terminated abnormally: received signal SIGBUS main_program: APT_PMsectionLeader(2, node2), player 7 - Unexpected exit status 1. APT_PMsectionLeader(1, node1), player 8 - Unexpected exit status 1. The "SIGBUS" error is a unix memory access error that occurs when...

ray.wurlod wrote: These functions do not exist in the Transformer stage.

Sorry Ray...was little confused

devidotcom wrote:This issue is yet open.. can anyone help. Now values i used for the environment variables did not work for jobs which had record count >100000.

Please help.

Which environment variables are creating the error? Provide the complete error log.

--Tony

TRIML and TRIMT functions in a transformer with "0" specified as the character to be removed.

--Tony

ds_dwh wrote:co1,col2,col3
100,a,hyd
101,b,hyd
102,c,blore

Remove Duplicate stage works based on a key column. Firstly, What is your key column? And also your required output is unclear.

Thanks,
Tony

This may indicate a system error when lots of processes are running in parallel at the same point. Check if you've get a core file generated in $DSHOME and your DataStage project directory, if yes then it is mostly a memory leaking issue. Try recompliling the job after restarting the server. It migh...

you can check few other things also for example: 1) there is only one and only one @ symbol available in email id 2) no occurrence of two consecutive periods i.e. (..) You can add an indexed lookup for the known Mail service providers to the above two checks for better results. :wink: Thanks, Tony

The syntax for mentioning a record in a schema file is
Example Thanks,
Tony

Check for the value of the APT_TRANSFORM environment variable in the server

Thanks,
Tony

One or two examples of the complex elements can make things easier to think about an alternate ETL design.

Thanks,
Tony

If the file's table definition is defined as fixed length columns, then the load will be automatically done. In the table definition if the length of the columns are specified exactly, then the nulls also will have spaces equal to the length mentioned. The data is coming like this. Batch_ID file_na...

If the file's table definition is defined as fixed length columns, then the load will be automatically done.

Firstly, Did you try loading data in to the target file?

Thanks,
Tony

1. There is an option to set Configuration File in every stage. For example, I might want to use a different configuration file in a Join Stage and use a different one in a Copy Stage. DataStage gives us that flexibility, however, for some reason, it is not enabled in my project. I'm not sure wheth...

DS1 has plainty of columns, so just a sample: Code|Group|Detail| 123|"A"|"Hello" 123|"B"|"Bye" 300|"C"| 900|"A"|"World" DS2 has only two columns: Code|Key_Col 123|1 300|2 900|3 I want to have on my output: Code|Group|Detail|Key_C...

Wont "Help" button take you to "DOCUMENTATION" link..?

-Tony