I'm having trouble selecting data from a Sybase view using the Sybase Enterprise stage. I confirmed with our DBA that DataStage is connecting to the database server, but when I "View Data" it comes back with no rows and the following log:
##I TUTL 000031 11:08:56(001) <main_program> The open files limit is 100; raising to 2048.
##I TOSH 000002 11:08:57(000) <main_program> orchgeneral: loaded
##I TOSH 000002 11:08:57(001) <main_program> orchsort: loaded
##I TOSH 000002 11:08:57(002) <main_program> orchstats: loaded
##I TFSC 000001 11:08:57(003) <main_program> APT configuration file: /opt/etl/Ascential/DataStage/Configurations/default.apt
##W TFPA 000017 11:08:57(004) <main_program> Warning: the value of the PWD environment variable (/opt/etl/Ascential/DataStage/DSEngine) does not appear to be a synonym for the current working directory (/opt/etl/Ascential/DataStage/Projects/BDR_DEVL). The current working directory will be used, but if your ORCHESTRATE job does not start up correctly, you should set your PWD environment variable to a value that will work on all nodes of your system.
##W TCOS 000049 11:08:58(000) <main_program> Parameter specified but not used in flow: _BIMSUSER
##W TCOS 000049 11:08:58(001) <main_program> Parameter specified but not used in flow: _BIMSPWD
##W TCOS 000049 11:08:58(002) <main_program> Parameter specified but not used in flow: _DMSERVER
##W TCOS 000049 11:08:58(003) <main_program> Parameter specified but not used in flow: _CQUSER
##W TCOS 000049 11:08:58(004) <main_program> Parameter specified but not used in flow: _CQPASSWORD
##W TCOS 000049 11:08:58(005) <main_program> Parameter specified but not used in flow: _CQSERVER
##I SYBO 000000 11:08:59(000) <main_program> SCW_INFO: Initiating SCW
##I SYBO 000000 11:08:59(001) <main_program> SRVER Error: Changed database context to 'ref_confidential'.
##I SYBO 000000 11:08:59(002) <main_program> SCW_INFO:Connection Established
There are about 4000 rows that should be selected, and I can select them using a separate sql client called JSQL. Just wondering if any one has handled this issue.
Thanks,
Sybase Issue
Moderators: chulett, rschirm, roy
Hi,
What Sybase version?
What DS version?
Does the manuals say your DS version supports the Sybase version?
(safer to also ask your support provider)
Which OS?
Are they both on the same server?
Does it work in server jobs?
I'm not sure using that JSQL is identical to using DS plugins.
What Sybase version?
What DS version?
Does the manuals say your DS version supports the Sybase version?
(safer to also ask your support provider)
Which OS?
Are they both on the same server?
Does it work in server jobs?
I'm not sure using that JSQL is identical to using DS plugins.
Roy R.
Time is money but when you don't have money time is all you can afford.
Search before posting:)
Join the DataStagers team effort at:
http://www.worldcommunitygrid.org
Time is money but when you don't have money time is all you can afford.
Search before posting:)
Join the DataStagers team effort at:
http://www.worldcommunitygrid.org
