DSXchange

Check the permission on given directory outside the datasatge

Hi, I have job which loads data into db2 table via db2 stage. While loading some of the reords are getting rejected becuase pr primary key constriant. I am able to capture these records in transformer link ( reject link) can any body tell me how to capture SQL error code thrown by db2 in Transfermer...

hii, I am much new to DS - PX and going through documentation. Following are my questions while going through it. What is USS systems? What is NLS?(National Language support) What are SMP,MPP,Cluster system? What is XML? What is number of CPU licensed in context of installation? What is user limit i...

Anybody having any update on that

I am getting following error.... test_Sql_from_file..DB2_Read_Source_Row_Count: [IBM][CLI Driver][DB2/NT] SQL0007N The character "\" following "E:" is not valid. SQLSTATE=42601 SQLExecDirect: Error executing statement 'E:\Dump\Sandeep\Query.txt '. See following DB2 message for de...

hi All I am new to server environment. I am using DB2/UDB API and trying to see data of table by sql query present in file. For that I have did following things 1) Set Outputpage - General tab to Load SQL from file at run time 2) Set Outputpage - SQL query to Load SQL from file at run time 3) given ...

Hi,

Is there is any Datastage versopn of parallel extender/Enterprise edition which works on windows.

hii,

can somebody tell general cause behind error "input buffer overrun".

i have field containing packed decimal..and i am trying to read it as

decimal[9,3] {packed};
and I am getting error "input buffer overrun"

the field having packed decimal is PIC S9(6)V999 COMP-3.

What I want to do is: Read whole sql output as one column and then at column import stage based on schema file provided convert it to columns. This I have to use since we cannot provide schema file in Oracle Enterprise Stage. I hope above text will help you in understanding the problem exactly. Than...

I am using Column Import Stage after Oracle stage getting following error. I have provided Ora_Sql_Data as an input column to Column Import Stage:

##E TOIX 000000 13:46:02(003) <Column_Import_80> Import field "Ora_Sql_Data" was not found in the input data set schema.

Thanks,
Ashish

No. There is a stage type called Generic. RTFM? ... ya but i am calling transform operator...from generic stage..... in a job if i put only one generic stage then it;s works fine.....problem is with secong genric stage.....it seems that job is just ignoring second generic stage....even preint_messa...

Hi All, I have job which has a sequential stage followed by two generic staage and a final sequential file stage. In first generic stage I am copying input to output...say... out.inputcolumn=in.inputcolumn and in second generic stage i am doing in.inputcolumn=substring(in.inputcolumn, 0,1) my proble...

ray.wurlod wrote:No. RCP handles missing metadata, not missing data. You need to specify a default value in the column metadata to handle the situation you described. ...

Thanks ray,

I also want to know whether it is possible to decribe partial schema and read the file with above case.

Thanks and regards
LK

hi...

i am reading a file using schema file....if I have schema file having columns say A,B,C and acutal data in file contain only two columns.....then is it possible to read that data file.....

IS RCP or partial schema property is useful for above step

thanks in advance
LK

Hi,

I need one information. Can we do looping among some stages of the job. For example say I have 7 stages then can I loop between stages 3,4,5 till certain condition in stage 3 satisfied.

Thanks,