ODBC Connector - SYSIBM.SYSDUMMY1

Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.

Moderators: chulett, rschirm, roy

Post Reply
algfr
Participant
Posts: 106
Joined: Fri Sep 09, 2005 7:42 am

ODBC Connector - SYSIBM.SYSDUMMY1

Post by algfr »

Hi folks,

I have a stupid question : I can query the SYSIBM.SYSDUMMY1 table in DBAS400 but cannot find it when I check the SYSIBM library using the ODBC Import table tool. I can see all tables except this one.

Is there something to configure in the ODBC connector ?

Thanks
Top
algfr
Participant
Posts: 106
Joined: Fri Sep 09, 2005 7:42 am

Post by algfr »

Meaning I can't see it from Datastage (I checked the rights, they're fine)
Top
ArndW
Participant
Posts: 16318
Joined: Tue Nov 16, 2004 9:08 am
Location: Germany
Contact:
Contact ArndW

Post by ArndW »

Perhaps it gets filtered from the dropdown list. Try to use the table in job and see what your error message(if any) is.
Top
algfr
Participant
Posts: 106
Joined: Fri Sep 09, 2005 7:42 am

Post by algfr »

ArndW wrote:Perhaps it gets filtered from the dropdown list. Try to use the table in job and see what your error message(if any) is. ...
Hi ArndW,

Well I filter the list using the SYSIBM library.

I get this error message, doesn't help much...

##I IIS-DSEE-TFCN-00001 11:09:52(000) <main_program>
IBM WebSphere DataStage Enterprise Edition 8.0.1.5049
Copyright (c) 2001, 2005-2007 IBM Corporation. All rights reserved



##I IIS-DSEE-TOSH-00002 11:09:52(001) <main_program> orchgeneral: loaded
##I IIS-DSEE-TOSH-00002 11:09:52(002) <main_program> orchsort: loaded
##I IIS-DSEE-TOSH-00002 11:09:52(003) <main_program> orchstats: loaded
##W IIS-DSEE-TOSH-00049 11:09:53(000) <main_program> Parameter specified but not used in flow: ps_ODBC_TDW_EU_BL
##W IIS-DSEE-TOSH-00049 11:09:53(001) <main_program> Parameter specified but not used in flow: ps_TDW_FileDirectories
##W IIS-DSEE-TOSH-00049 11:09:53(002) <main_program> Parameter specified but not used in flow: ps_ORA_DWH_SALES_MARKETING
##W IIS-DSEE-TOSH-00049 11:09:53(003) <main_program> Parameter specified but not used in flow: p_LOAD_ID
##W IIS-DSEE-TOSH-00049 11:09:53(004) <main_program> Parameter specified but not used in flow: p_TargetTableName
##W IIS-DSEE-TOSH-00049 11:09:53(005) <main_program> Parameter specified but not used in flow: p_StateFile
##I IIS-DSEE-TDOD-00080 11:09:55(000) <drs_odbc_PRODUCT_LOCAL> Process meta data not available in database
##I IIS-DSEE-TFSC-00001 11:09:56(005) <main_program> APT configuration file: /da915m00/IBM/InformationSerer/Server/Configurations/config2x.apt
##I IIS-DSEE-TOPK-00013 11:09:58(000) <_PEEK_IDENT_,0> --.
**VIEWDATA ROW LIMITER HIT**
>##E IIS-DSEE-TFOR-00089 11:09:58(001) <_ABORT_IDENT_,0> The runLocally() of the operator failed.
##I IIS-DSEE-USBP-00001 11:09:58(000) <APT_CombinedOperatorController,0> called postFinalRunLocally
##I IIS-DSEE-TFOR-00163 11:09:58(002) <_ABORT_IDENT_,0> Input 0 consumed 0 records.
>##E IIS-DSEE-TFOR-00089 11:09:58(003) <APT_CombinedOperatorController,0> The runLocally() of the operator failed.
>##E IIS-DSEE-TFPM-00040 11:09:58(004) <APT_CombinedOperatorController,0> Operator terminated abnormally: runLocally did not return APT_StatusOk
>##E IIS-DSEE-TFSC-00011 11:10:04(000) <main_program> Step execution finished with status = FAILED.
##I IIS-DSEE-TCOS-00026 11:10:04(001) <main_program> Startup time, 0:08; production run time, 0:03.
Top
algfr
Participant
Posts: 106
Joined: Fri Sep 09, 2005 7:42 am

Post by algfr »

I've got it, it was my row skipped option in the data viewer.

I'm so sorry ... javascript:emoticon(':oops:')
algfr wrote:
ArndW wrote:Perhaps it gets filtered from the dropdown list. Try to use the table in job and see what your error message(if any) is. ...
Hi ArndW,

Well I filter the list using the SYSIBM library.

I get this error message, doesn't help much...

##I IIS-DSEE-TFCN-00001 11:09:52(000) <main_program>
IBM WebSphere DataStage Enterprise Edition 8.0.1.5049
Copyright (c) 2001, 2005-2007 IBM Corporation. All rights reserved



##I IIS-DSEE-TOSH-00002 11:09:52(001) <main_program> orchgeneral: loaded
##I IIS-DSEE-TOSH-00002 11:09:52(002) <main_program> orchsort: loaded
##I IIS-DSEE-TOSH-00002 11:09:52(003) <main_program> orchstats: loaded
##W IIS-DSEE-TOSH-00049 11:09:53(000) <main_program> Parameter specified but not used in flow: ps_ODBC_TDW_EU_BL
##W IIS-DSEE-TOSH-00049 11:09:53(001) <main_program> Parameter specified but not used in flow: ps_TDW_FileDirectories
##W IIS-DSEE-TOSH-00049 11:09:53(002) <main_program> Parameter specified but not used in flow: ps_ORA_DWH_SALES_MARKETING
##W IIS-DSEE-TOSH-00049 11:09:53(003) <main_program> Parameter specified but not used in flow: p_LOAD_ID
##W IIS-DSEE-TOSH-00049 11:09:53(004) <main_program> Parameter specified but not used in flow: p_TargetTableName
##W IIS-DSEE-TOSH-00049 11:09:53(005) <main_program> Parameter specified but not used in flow: p_StateFile
##I IIS-DSEE-TDOD-00080 11:09:55(000) <drs_odbc_PRODUCT_LOCAL> Process meta data not available in database
##I IIS-DSEE-TFSC-00001 11:09:56(005) <main_program> APT configuration file: /da915m00/IBM/InformationSerer/Server/Configurations/config2x.apt
##I IIS-DSEE-TOPK-00013 11:09:58(000) <_PEEK_IDENT_,0> --.
**VIEWDATA ROW LIMITER HIT**
>##E IIS-DSEE-TFOR-00089 11:09:58(001) <_ABORT_IDENT_,0> The runLocally() of the operator failed.
##I IIS-DSEE-USBP-00001 11:09:58(000) <APT_CombinedOperatorController,0> called postFinalRunLocally
##I IIS-DSEE-TFOR-00163 11:09:58(002) <_ABORT_IDENT_,0> Input 0 consumed 0 records.
>##E IIS-DSEE-TFOR-00089 11:09:58(003) <APT_CombinedOperatorController,0> The runLocally() of the operator failed.
>##E IIS-DSEE-TFPM-00040 11:09:58(004) <APT_CombinedOperatorController,0> Operator terminated abnormally: runLocally did not return APT_StatusOk
>##E IIS-DSEE-TFSC-00011 11:10:04(000) <main_program> Step execution finished with status = FAILED.
##I IIS-DSEE-TCOS-00026 11:10:04(001) <main_program> Startup time, 0:08; production run time, 0:03.
Top
Post Reply

Return to “IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)”