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.

I have troubles with infomaker

2 posts in PB Infomaker Report Writer Last posting was on 1999-04-16 01:58:54.0Z
Julio Sanchez Posted on 1999-04-04 03:52:51.0Z
Newsgroups: sybase.public.infomaker.general
From: "Julio Sanchez" <rejmess@netgate.com.uy>
Subject: I have troubles with infomaker
Date: Sun, 4 Apr 1999 00:52:51 -0300
Lines: 78
X-Newsreader: Microsoft Outlook Express 4.72.3110.5
X-MimeOLE: Produced By Microsoft MimeOLE V4.72.3110.3
Message-ID: <348_R6ecKU4h#GA.269@forums.sybase.com>
Path: forums-1-dub!forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.infomaker.general:6422
Article PK: 241407

Powersoft,
Present.


My name is Julio Sánchez. I work daily with InfoMaker 5.0, and i
have some troubleshooting when i write SQL statement for reports.I connect
using ODBC to Oracle 7.3 database. Here is my trouble.

I start a report, i go to convert to syntax, and became to write
the
SQL statement. Then when i try to go to report by clicking at the SQL icon,
it
gave me several messages of incorrect syntax. I look at the manuals of
Oracle
Server Error Messages and the error are of incorrect syntax , for examples
(
and the recurrent message ) 936 - Missing Expresion, 933 - From not found
where expected, etc. I cut and paste the same SQL sentence from Infomaker
to SQL Plus 3.3 window, and it works without any trouble.

Another thing that happened is based on the next SQL statement:


SELECT A.CANTIDAD,
B.CANTIDAD,
B.COMERCIO
FROM ( SELECT SUM( CANT ) CANTIDAD ,
COMERCIO
FROM TABLA1
WHERE ( FECHA BETWEEN 19990101 AND 19990103 )
GROUP BY COMERCIO ) A,
( SELECT COUNT( COMERCIO ) CANTIDAD ,
COMERCIO
FROM TABLA2
WHERE ( FECHA BETWEEN 19990101 AND 19990103 )
GROUP BY COMERCIO ) B
WHERE ( A.COMERCIO = B.COMERCIO )

The InfoMaker gave me a thousand of errors when i was writing it,
and i paste it on the SQL Plus window and it works. I still don't now how
but
cuting from one window to another, writing on the notepad, and don't now
how many things i try, finnaly InfoMaker accept it as a valid SQL
statement.
I was so happy, then when execute the report the data that infomaker show
are
trash, it put me lines and lines of infinite values, values for Comercio
that
doesn't exist on the Database, and it is a report for my superior, it ask me
every day for the report, and gave to she at a file resulting of execute the
SQL
statement in a SQL Plus window, so in the SQL Plus window the result is ok
but the InfoMaker doesn't return what i expected, and how should i now when
the data that the InfoMaker retrieve is ok.




I will glad if u answer back this e-mail, no mather if you have the solution
or
not.


Julio Sánchez

E-mail : rejmess@netgate.com.uy
Telephone: Home - ( 598 ) 2 - 902 - 18 - 95.
Work - ( 598 ) 2 - 908 - 90 - 80 internal
207.
Address - 917, Uruguay Street.
Montevideo - 11.100 - Uruguay
South America


Terry Dykstra Posted on 1999-04-16 01:58:54.0Z
Newsgroups: sybase.public.infomaker.general
From: "Terry Dykstra" <tdykstra@cfol.ab.ca>
Subject: Re: I have troubles with infomaker
Date: Thu, 15 Apr 1999 19:58:54 -0600
Lines: 104
X-Newsreader: Microsoft Outlook Express 4.72.3110.5
X-MimeOLE: Produced By Microsoft MimeOLE V4.72.3110.3
Message-ID: <348_yds3mw6h#GA.310@forums.sybase.com>
References: <348_R6ecKU4h#GA.269@forums.sybase.com>
Path: forums-1-dub!forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.infomaker.general:6421
Article PK: 241404

Julio,

Infomaker has a problem that it sometimes doesn't handle carriage returns
properly. Make sure that at the end of each line you have a space.
If the FECHA column is a date type, use the to_date() function:
FECHA BETWEEN todate('19990101','YYYYMMDD') AND
to_date('19990103','YYYYMMDD' )

Because something works in SQL/Plus, doesn't mean it will work in other
tools. SQL/Plus uses its own mechanism and doesn't rely on for instance
ODBC.
Oracle's ODBC drivers are notoriously bad. The only one that seems to be
pretty reliable is 2.0.03. Why don't you use the native driver, instead of
ODBC? If your current IM5 doesn't support it, get the 5.0.04 patch. It is
very stable and contains lots of bug fixes:
http://support.sybase.com/esd/pb_win_maint_5004.html

--
Terry Dykstra (TeamPS)
Canadian Forest Oil Ltd.

Julio Sanchez wrote in message ...
>
>Powersoft,
>Present.
>
>
> My name is Julio Sánchez. I work daily with InfoMaker 5.0, and i
>have some troubleshooting when i write SQL statement for reports.I connect
>using ODBC to Oracle 7.3 database. Here is my trouble.
>
> I start a report, i go to convert to syntax, and became to write
>the
>SQL statement. Then when i try to go to report by clicking at the SQL icon,
>it
> gave me several messages of incorrect syntax. I look at the manuals of
>Oracle
> Server Error Messages and the error are of incorrect syntax , for examples
>(
> and the recurrent message ) 936 - Missing Expresion, 933 - From not found
> where expected, etc. I cut and paste the same SQL sentence from Infomaker
>to SQL Plus 3.3 window, and it works without any trouble.
>
> Another thing that happened is based on the next SQL statement:
>
>
> SELECT A.CANTIDAD,
> B.CANTIDAD,
> B.COMERCIO
> FROM ( SELECT SUM( CANT ) CANTIDAD ,
> COMERCIO
> FROM TABLA1
> WHERE ( FECHA BETWEEN 19990101 AND 19990103 )
> GROUP BY COMERCIO ) A,
> ( SELECT COUNT( COMERCIO ) CANTIDAD ,
> COMERCIO
> FROM TABLA2
> WHERE ( FECHA BETWEEN 19990101 AND 19990103 )
> GROUP BY COMERCIO ) B
> WHERE ( A.COMERCIO = B.COMERCIO )
>
> The InfoMaker gave me a thousand of errors when i was writing it,
>and i paste it on the SQL Plus window and it works. I still don't now how
>but
>cuting from one window to another, writing on the notepad, and don't now
>how many things i try, finnaly InfoMaker accept it as a valid SQL
>statement.
>I was so happy, then when execute the report the data that infomaker show
>are
>trash, it put me lines and lines of infinite values, values for Comercio
>that
>doesn't exist on the Database, and it is a report for my superior, it ask
me
>every day for the report, and gave to she at a file resulting of execute
the
>SQL
>statement in a SQL Plus window, so in the SQL Plus window the result is ok
>but the InfoMaker doesn't return what i expected, and how should i now when
>the data that the InfoMaker retrieve is ok.
>
>
>
>
>I will glad if u answer back this e-mail, no mather if you have the
solution
>or
>not.
>
>
> Julio Sánchez
>
> E-mail : rejmess@netgate.com.uy
> Telephone: Home - ( 598 ) 2 - 902 - 18 - 95.
> Work - ( 598 ) 2 - 908 - 90 - 80 internal
>207.
> Address - 917, Uruguay Street.
> Montevideo - 11.100 - Uruguay
> South America
>
>
>
>
>