I have an embedded SQL statement in a SQLCBL program. Last night I just added two new numeric fields I need to select. Now AS400 is telling me that the variables are either not defined or not usable. This program (SQL) was working before I added the new variables/fields. New fields in table are decimal packed with NO NULL option.
Any feedback will be appeciated. I am running out of ideas.
Thanks
Marc
01 holdarchivbox pic 9(7) comp-3.
01 holdarchivpage pic 9(5) comp-3.
SQL statement
SQL exec sql
SQL select crdattim,
SQL objectid,
SQL objtype,
SQL archivbox,
SQL archivpage
SQL into :holdcrdattim,
SQL :holdobjectid,
SQL :holdobjecttyp,
SQL :holdarchivbox,
SQL :holdarchivpage
SQL from w00u999s
SQL where crdattim = :hldchildcdt
SQL end-exec
2  7929 
I have an embedded SQL statement in a SQLCBL program. Last night I just added two new numeric fields I need to select. Now AS400 is telling me that the variables are either not defined or not usable. This program (SQL) was working before I added the new variables/fields. New fields in table are decimal packed with NO NULL option.
Any feedback will be appeciated. I am running out of ideas.
Thanks
Marc
01 holdarchivbox pic 9(7) comp-3.
01 holdarchivpage pic 9(5) comp-3.
SQL statement
SQL exec sql
SQL select crdattim,
SQL objectid,
SQL objtype,
SQL archivbox,
SQL archivpage
SQL into :holdcrdattim,
SQL :holdobjectid,
SQL :holdobjecttyp,
SQL :holdarchivbox,
SQL :holdarchivpage
SQL from w00u999s
SQL where crdattim = :hldchildcdt
SQL end-exec
we encountered the same error, try this
01 holdarchivbox pic S9(7) comp-3.
01 holdarchivpage pic S9(5) comp-3.
This discussion might be better placed in either the MySQL forum or the SQL Server forum - if you let me know which is more appropriate, I can move the thread there, and you will get more feedback.
Sign in to post your reply or Sign up for a free account.
Similar topics
by: amit |
last post by:
I am trying to compile the sample program genwin.sqc, using nsqlprep
which is used to precompile embedded sql in C. I am getting weird
errors and that is because windows.h is included in the...
|
by: Jean-David Beyer |
last post by:
I have some programs running on Red Hat Linux 7.3 working with IBM DB2
V6.1 (with all the FixPacks) on my old machine.
I have just installed IBM DB2 V8.1 on this (new) machine running Red Hat...
|
by: deanclowe |
last post by:
Hi I have a query that is trying to use a field that is created "AS"
based on a case statement like this:
SELECT
CASE
WHEN IPOVH = 'Y' THEN '01'
WHEN IPHSI = 'Y' ...
|
by: Mike Owen |
last post by:
Hi,
I am trying to pre-compile a project prior using ASP.Net 2.0, VS 2005, to
putting it onto a live server.
The reason for doing this is that other people have access to the server,
and I...
|
by: cjeschke |
last post by:
Using PRO*C precompiler on windows, I precompile my c code with embedded Oracle 9.2 queries. When I link the program including all the Oracle 9.2 libraries I can find, i get an undefined _sqlcxt:
...
|
by: Shimon Sim |
last post by:
I tried to use Precompile.axd to compile my site but got HTTP404 (The
resource cannot be found) instead. I am running ASP.NET Version:2.0.50727.42
..
Any suggestions?
Thank you,
Shimon.
|
by: comp.lang.php |
last post by:
I am trying to debug an error found somewhere within my suite of
scripts. Nothing shows up when there's an error, it just simply dies.
I tried using error_reporting(E_ALL); to no avail. I tried...
|
by: Johan Neidenmark |
last post by:
When i try to run this SQL statements in iSeries Access for windows
(against my customers db2) i get:
SQL State: 42904
Vendor Code: -7032
Message: SQL procedure, function, or trigger...
|
by: =?Utf-8?B?SGVybWF3aWg=?= |
last post by:
Hello,
Please anybody help me.
I have only a little experience with web development.
I created simple project using ASP NET 2.0 (VS 2005)
It works fine on local computer.
When I tried to run...
|
by: Charles Arthur |
last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
|
by: emmanuelkatto |
last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud.
Please let me know.
Thanks!
Emmanuel
|
by: BarryA |
last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
|
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
|
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers,...
|
by: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...
|
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...
|
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome a new...
| |
