Sybase NNTP forums - End Of Life (EOL)

The NNTP forums from Sybase - forums.sybase.com - are now closed.

All new questions should be directed to the appropriate forum at the SAP Community Network (SCN).

Individual products have links to the respective forums on SCN, or you can go to SCN and search for your product in the search box (upper right corner) to find your specific developer center.

SyntaxFromSQL support on 3.0 - Dynamic DW

4 posts in Appeon (partner product) Last posting was on 2005-07-26 09:33:38.0Z
KillerBayawak Posted on 2005-07-22 02:17:42.0Z
Sender: 695f.42e056b0.1804289383@sybase.com
From: KillerBayawak
Newsgroups: sybase.public.appeon
Subject: SyntaxFromSQL support on 3.0 - Dynamic DW
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <42e05742.6968.1681692777@sybase.com>
X-Original-NNTP-Posting-Host: 10.22.241.42
X-Original-Trace: 21 Jul 2005 19:17:38 -0700, 10.22.241.42
Lines: 27
X-Original-NNTP-Posting-Host: forums-2-dub.sybase.com
X-Original-Trace: 21 Jul 2005 19:17:39 -0700, forums-2-dub.sybase.com
NNTP-Posting-Host: forums-master.sybase.com
X-Original-NNTP-Posting-Host: forums-master.sybase.com
Date: 21 Jul 2005 19:17:42 -0700
X-Trace: forums-1-dub 1121998662 10.22.108.75 (21 Jul 2005 19:17:42 -0700)
X-Original-Trace: 21 Jul 2005 19:17:42 -0700, forums-master.sybase.com
X-Authenticated-User: ngsysop
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.appeon:982
Article PK: 12789

Hi! Is the Transaction object function SyntaxFromSQL() fully
supported? I'm having problems using this function. Here's
the script on the Open() event of the window:

//////////
String ls_sql, ls_syntax, ls_err, ls_style

ls_sql = "SELECT EMP_ID, EMP_FNAME, EMP_LNAME FRM EMPLOYEE"
ls_style = "Style(Type=Grid)"

ls_syntax = SQLCA.SyntaxFromSQL(ls_sql, ls_style, ls_err)

dw_1.Create(ls_syntax, ls_err)
dw_1.SetTransObject(SQLCA)
dw_1.Retrieve()
///////////////

The function SyntaxFromSQL executes successfully(error
variable is empty) but the output syntax is empty. Prior to
this, I've installed the SQL script
"install_appeon_syntaxfromsql_ORACLE.sql".

Please specify if I'm doing something wrong. I'm using
Appeon 3.0 (Xcelerator), PB 9.0.2 Build 7578, Oracle 9i, and
Windows XP SP2.

Thanks.


Julie Jiang Posted on 2005-07-25 11:26:46.0Z
From: "Julie Jiang" <julie.jiang@appeon.net>
Newsgroups: sybase.public.appeon
References: <42e05742.6968.1681692777@sybase.com>
Subject: Re: SyntaxFromSQL support on 3.0 - Dynamic DW
Lines: 151
MIME-Version: 1.0
Content-Type: multipart/alternative; boundary="----=_NextPart_000_001A_01C5914E.BC688450"
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2800.1106
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1106
X-Original-NNTP-Posting-Host: 210.21.221.178
Message-ID: <42e4cc72@forums-2-dub>
X-Original-Trace: 25 Jul 2005 04:26:42 -0700, 210.21.221.178
X-Original-NNTP-Posting-Host: forums-2-dub.sybase.com
X-Original-Trace: 25 Jul 2005 04:26:43 -0700, forums-2-dub.sybase.com
NNTP-Posting-Host: forums-master.sybase.com
X-Original-NNTP-Posting-Host: forums-master.sybase.com
Date: 25 Jul 2005 04:26:46 -0700
X-Trace: forums-1-dub 1122290806 10.22.108.75 (25 Jul 2005 04:26:46 -0700)
X-Original-Trace: 25 Jul 2005 04:26:46 -0700, forums-master.sybase.com
X-Authenticated-User: ngsysop
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.appeon:985
Article PK: 12793

There are just several minor limitations on the SyntaxFromSQL support, as described in Appeon Help: (1) The following syntax is unsupported: ls_dw_syntax = SyntaxFromSQL(sqlca, ls_sql_syntax, ls_style, ls_dw_err).  (2) The length of return value on the Web is different from PowerBuilder.  (3) The return value of the SyntaxFromSQL function on the Web contains a column name for each column although it is not in PowerBuilder.
 
The empty output syntax in your case should not be caused by unsupported feature, but due to misconfiguration.  Please do the following changes/checkings:
1) The SQL "SELECT EMP_ID, EMP_FNAME, EMP_LNAME FRM EMPLOYEE" is incorrect.  Please change “FRM” to “FROM” in your SQL.
 
2) Make sure you configured connection cache for the target application in AEM (Appeon Enterprise Manager).  You should first create a cache in EAServer, and then set the mapping between the cach and transaction object in AEM.
 
3) Make sure that the sp_appeon_syntaxfromsql_ORACLE.sql is installed as the table owner. That is to say, the user name and password you used to install the sql should match what you've specified in EAServer Manager when configuring the connection cache.
 
Regards,
Julie
 
<KillerBayawak> wrote in message news:42e05742.6968.1681692777@sybase.com...
Hi! Is the Transaction object function SyntaxFromSQL() fully
supported? I'm having problems using this function. Here's
the script on the Open() event of the window:

//////////
String ls_sql, ls_syntax, ls_err, ls_style

ls_sql = "SELECT EMP_ID, EMP_FNAME, EMP_LNAME FRM EMPLOYEE"
ls_style = "Style(Type=Grid)"

ls_syntax = SQLCA.SyntaxFromSQL(ls_sql, ls_style, ls_err)

dw_1.Create(ls_syntax, ls_err)
dw_1.SetTransObject(SQLCA)
dw_1.Retrieve()
///////////////

The function SyntaxFromSQL executes successfully(error
variable is empty) but the output syntax is empty. Prior to
this, I've installed the SQL script
"install_appeon_syntaxfromsql_ORACLE.sql".

Please specify if I'm doing something wrong. I'm using
Appeon 3.0 (Xcelerator), PB 9.0.2 Build 7578, Oracle 9i, and
Windows XP SP2.

Thanks.


Julie Jiang Posted on 2005-07-26 09:33:38.0Z
From: "Julie Jiang" <julie.jiang@appeon.net>
Newsgroups: sybase.public.appeon
References: <42e4cc72@forums-2-dub> <42e4f944.23bc.1681692777@sybase.com>
Subject: Re: SyntaxFromSQL support on 3.0 - Dynamic DW
Lines: 163
MIME-Version: 1.0
Content-Type: multipart/alternative; boundary="----=_NextPart_000_00C4_01C59207.C7783F20"
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2800.1106
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1106
NNTP-Posting-Host: 218.18.114.119
X-Original-NNTP-Posting-Host: 218.18.114.119
Message-ID: <42e60372@forums-1-dub>
Date: 26 Jul 2005 02:33:38 -0700
X-Trace: forums-1-dub 1122370418 218.18.114.119 (26 Jul 2005 02:33:38 -0700)
X-Original-Trace: 26 Jul 2005 02:33:38 -0700, 218.18.114.119
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.appeon:990
Article PK: 12794

For Oracle database, please use Oracle native driver, and not JDBC-ODBC bridge for configuring the connection cache.   JDBC-ODBC bridge is not a certified driver for Oracle and has very possibly caused the error you described.  You can get the native driver from http://otn.oracle.com/software/tech/java/sqlj_jdbc/index.html. 
 
After you copy the Oracle driver to %JAGUAR%\java\lib\, you can configure the cache with the following parameters.
In the General tab page:
Server Name: jdbc:oracle:thin:@192.0.2.189:1521:oracle9  (oracle9 should be replaced with the SID of your database)
User Name: test                
Password: ****
In the Driver tab page:
Database Driver Type: JDBC
DLL or Class Name: oracle.jdbc.driver.OracleDriver
 
Regarding your question, "is the success of the function SyntaxFromSQL on Appeon depending on the tables/stored procs that was installed?", our answer is "yes".  Appeon does not require additional configurations except for the stored procs installation.
 
Regards,
Julie 
<KillerBayawak> wrote in message news:42e4f944.23bc.1681692777@sybase.com...
Hi Julie,

Thank you very much for your reply.

I'm sorry for the typo but the embedded SQL statement I used
was actually "FROM" so I think there's no problem with that.

Also, I have already configured a connection cache in
EAServer, a JDBC-ODBC bridge, and mapped it in AEM making
sure the transaction object was using the conn cache that I
just made.

About the SQL script (sp_appeon_syntaxfromsql_ORACLE.sql)
that Appeon has provided, I realized it created PB catalog
tables, global temp tables, a package, and stored procs in
the Oracle database, was this correct?... What kind of
additional tweaking should I do on the tables/stored procs
aside from making sure that the user I should use on the
EAServer Conn Cache must be the same as the one that I
should use to run the install script?

Also one more thing, is the success of the function
SyntaxFromSQL on Appeon depending on the tables/stored procs
that was installed?