DSXchange

i have declared the variable hand = DSJ.ME v_jobName = DSGetJobInfo (hand,DSJ.JOBNAME) when i compile the routine i get the error Variable 'DSJ.ME' never assigned a value. Array 'DSGetJobInfo' never dimensioned. WARNING: Variable 'DSJ.JOBNAME' never assigned a value. how could i resolve this issue

Hi all,

please tell the use and the purpose of DSJ.ME .

hand = DSJ.ME

v_jobName = DSGetJobInfo (hand,DSJ.JOBNAME)

what does the above piece of code do?
Please tell me how to exactly use it

Hi all, I saw a routine with the code like this If InputArg = '' Then Call DSLogWarn('InputArg is required.' , c_routineName ); Return End v_OPID = '100' v_logFolder = 'dir' Ans=v_OPID IN THIS IF MY INPUT ARGUMENT IS NULL WHAT WILL HAPPEN. WHAT DOES THE RETURN STATEMENT DO? WILL IT RETURN BACK TO LI...

Hi all,
I get the following error when i use Link Collector in my job.

".Link_Collector: |Error 11 in GCI Link initialisation".

what is the reason for this?How can i resolve this.

The no records that i process is very huge ,around 50 lakhs

IPC stage doesn't timeout if your truncate process takes long. It would help us if you can show the process flow clearly by putting code or image tags around them. sourceoracle----transformer----IPC---target | | | input---procedure--transformer---hashedfile for truncating after truncating is done f...

The truncation portion of your job occurs outside of the IPC stage timeout. ... The process flows like this oraclestage---transformer--- IPC----target ------------------------- | ------------------------- | successfulltruncate partition i have delayed the process such that only after successful com...

Hi all, I have logic that is implemented as below, first i truncate all the target tables partitions and then only the loading of the data from the source to target will take place.while loading i used an IPC stage and set the time out to 10 I have doubt whether this timeout will be sufficient for t...

Hi all, can we execute oracle queries through any Datastage function like how we execute unix commands. As when i want the output of a single select query 'select * from tablename' i put this in a sqlfile in my unix directory and execite this file through the unix commands in the routine and assign ...

chulett wrote:I'd suggest you look into a multi-instance job where the InvocationID macro is used to control the partition being loaded. run multiple instances instead.

can you please tell me how to use multi-instance job with the InvocationID
macro

Hi all, i have used oracle bulk load as below oraclestage--->transformer--->ipcstage-->many oracle bulk loads i get the following error BulkTestP..Oracle_OCI_Load_9: Internal Error: Unable to initialize the Direct Path Context ORA-00604: error occurred at recursive SQL level 1 ORA-00911: invalid cha...

Hi all, I have a requirement to insert very large no records about(20 corers of records) How can i make the process faster and improve the performance Please correct for the procedure that i have followed oraclestage---->transformer--->ipcstage---->oraclebulk load |------>icstage---->oraclebulk load...

Hi all, I want to look up with a column of a particular table1 with another table2 column and also check that also check that the date column of table 2 is in between the 2 date columns of table 1 How can i do this in datastage? The look up that i have used looks like select table2.col3 where table1...

Hi all,
I have manycolumns around 200 columns imorted from the database and while running the job i get the following error
inserted value too large for a columns,row rejected

How can i know which column value is too large..??

ArndW wrote:Is the datatype perhaps NCHAR? And what is your character encoding in both DS and your database? ...

how can i check what charater encoding is used in the database where as in datastage the NLS charater settings determines the charater encoding if i am right...??

Is the oracle database parameter 'NLS SEMANTICS' set to CHAR ? I had that case with the nls not activated in Datastage, and the code page of Oracle set to utf8. Nicolas I have nls setting in the datastage to be Project default (UTF8) in the oracle stage Is there any difference between the nls setti...