DSXchange

Hi, i am getting the follwoing error. I had check the null and it is not null in target and source but still i am getting this error. APT_CombinedOperatorController,0: Null in field "JOB_BATCH_GK "; the result is non-nullable and there is no handle_null to specify a default value. [api/int...

Hi, i am getting the following error in DB2 connector stage db2_Job_Def_Group,0: DB2 reported: SQLSTATE = 42S22: Native Error Code = -206: Msg = [IBM][CLI Driver][DB2/LINUXX8664] SQL0206N "DEFN_NUM" is not valid in the context where it is used. SQLSTATE=42703 [:0] here is the sql i used se...

hi sura,

No i didn't change the target table.

Hi zulfi,

Yes when i view data it shows not exactly the same date whech i enters.

hi sura, here is sequential file settings Record level Final delemiter :none Field level Delemiter : | Quote :none Hi ray, I get to know that value of date when i copy the records from spreadsheet to notepad in notepad its showing that values wheres i enter the yyyy-mm-dd format in spreadsheet.I use...

Hi, i am getting the following fatal error Job design lookup seq file with Db2 database 1 and put ino target table Db2 database1 . . seq file......................lkup......................xfm..............>db2 database The follwing error coming from reference Db2 database 1 db2_Job_Def_Group,0: DB2...

Hi,

I have create a column name EFFT_DT (DATE) and i enter 2011-04-03 in dummy flat file in notepad but its showing values like 40240 in sequential when i try to view data.i want 2011-04-03.Can someone helps me on this.

Also for column name EFFT_DT (DATE) i enter 2011-04-03 in dummy flat file but its showing values like 40240 .Can someone helps me on this.[/quote]

Hi, i have column name BAL_NAME(decimal 22,2).i have create a dummy file and give the value 345.22 while creating flat file but when in view data its showing 00000000000000000345.22 added zeros in front of values.how to get rid of zeros just want 345.22 Also for column name EFFT_DT (DATE) i enter 20...

Hi, i am loading from file to table while loading i am getting the follwing warning Copy_of_Sequential_File_AFS,0: Import consumed only 309bytes of the record's 310 bytes (no further warnings will be generated from this partition) [impexp/grouprep.C:916] node_Node4: Unrecognized module name "pf...

Hi all, I am new to PX and i am facing a problem while reading from a sequential file The file that i am using has | delimter and i have given the final delimiter as end and field delimiter as |. Still i am getting the below problem Copy_of_Sequential_File_AFS,0: Field "EFF_DT" delimiter n...

Hi i am getting the follwing errors while extarcting the data from file to peek stage seqfile.....>peek stage i have pipe delimiter file final delimiter ...end field dlimiter ..........| and quote none here is my file 123|abd|abd|abd|345.22|345.22|345.22|abd|123|123|abd|345.22|345.22|345.22|345.22|1...

Hi, i am trying to implement the logic in tranformer stage can somone help me on this how i can i use this transformation rule. (If {OBLT.OBL_COL_TT} in 0 to 99 then '0' else mid(ToText({OBLT.OBL_COL_TT},0,""),1,1))='2'and {OBLT_USER_DATA.USER_CD_2}='A')then 'N' and if {OBLT.OBL_COL_TT}in ...

qt_ky wrote:Are you talking about the Generate Report option under the Designer's File menu or something else like a custom report?

yes i am talking about the report generate under Designer's file menu.

hi ray,

I am already using the default style sheet but it couldn't shows the source and target stages description.The description is already in the description tab.