Just one more reason to look at replacing DDS with DDL...
-Eric
-----Original Message-----
From: rpg400-l-bounces@xxxxxxxxxxxx
[mailto:rpg400-l-bounces@xxxxxxxxxxxx] On Behalf Of DLee@xxxxxxxx
Sent: Friday, January 15, 2010 4:06 PM
To: rpg400-l@xxxxxxxxxxxx
Subject: Re: CPF5035 Data mapping error
This is a multipart message in MIME format.g this same problem I was.
Mine turned out to be invalid data in a field I wasn't even referencing
in the embedded sql program.
Too bad there isn't a way to ignore fields we don't need.
The invalid data on these records has been in existance since 2003, and
not causing any problems that I know of.
Until I tried to process the file with SQL this week.
At firs I thought it was just crappy test data until I looked in the
production files.
I ended up fixing all the data before I could get the program to run to
end of job.
Regards,
SWBC
9311 San Pedro Ave., Suite 600
San Antonio, TX 78216
Visit our website at www.swbc.com
rpg400-l-request@xxxxxxxxxxxx
Sent by: rpg400-l-bounces@xxxxxxxxxxxx
01/15/2010 03:51 PM
Please respond to
rpg400-l@xxxxxxxxxxxx
To
rpg400-l@xxxxxxxxxxxx
cc
Subject
RPG400-L Digest, Vol 9, Issue 51
Send RPG400-L mailing list submissions to
rpg400-l@xxxxxxxxxxxx
To subscribe or unsubscribe via the World Wide Web, visit
http://lists.midrange.com/mailman/listinfo/rpg400-l
or, via email, send a message with subject or body 'help' to
rpg400-l-request@xxxxxxxxxxxx
You can reach the person managing the list at
rpg400-l-owner@xxxxxxxxxxxx
When replying, please edit your Subject line so it is more specific
than "Re: Contents of RPG400-L digest..."
*** NOTE: When replying to this digest message, PLEASE remove all text
unrelated to your reply and change the subject line so it is meaningful.
Today's Topics:
1. Re: template in V6R1 (Scott Klement)
2. CPF5035 Data mapping error
(Gundermann, Glenn / Kuehne + Nagel / Tor ZI-A)
3. Re: CPF5035 Data mapping error (Alan Campin)
4. Re: CPF5035 Data mapping error (Loyd Goodbar)
5. Re: CPF5035 Data mapping error (Charles Wilt)
6. C Functions missing symbols _C_sig_* on CRTPGM (Darryl Freinkel)
7. Re: RPG overloading (was RPGV?) (Barbara Morris)
8. Re: C Functions missing symbols _C_sig_* on CRTPGM (Scott Klement)
9. Re: Unit Test Frameworks for RPGLE (Buck)
10. Re: C Functions missing symbols _C_sig_* on CRTPGM (Scott Klement)
----------------------------------------------------------------------
message: 1
date: Fri, 15 Jan 2010 12:43:55 -0600
from: Scott Klement <rpg400-l@xxxxxxxxxxxxxxxx>
subject: Re: template in V6R1
Yes. IBM takes great pains to keep things compatible from release to
release. They wouldn't break something like this.
David FOXWELL wrote:
Hi,
Will
D MyDS DS BASED ( TEMPLATE )
Still work after upgrade to V6R1? I see that TEMPLATE is a new keyword
for D specs.
Thanks.
------------------------------
message: 2
date: Fri, 15 Jan 2010 13:49:20 -0500
from: "Gundermann, Glenn / Kuehne + Nagel / Tor ZI-A"
<Glenn.Gundermann@xxxxxxxxxxxxxxxx>
subject: CPF5035 Data mapping error
Hi folks,
I searched the archives and didn't find anything to help me with my
error
so now that I have figured it out, I thought I would send this in case
it
might help someone in the future.
I have a DDL-described table, and among other columns, have one defined
as
follows:
PONUMBERS VARCHAR(760) CCSID 37 NOT NULL
I found that I needed the following control-spec in my rpg module:
h cvtopt(*novarchar)
because without this, the rpg dump listing showed that PONUMBERS was
CHAR
and not VCHAR.
So even if my getPOs procedure returns varying-length data:
D getPOs PI 760a varying
D orderType 4a const
D orderNumber 17a const
The following statement moves the returned data into a character field,
which then causes an error when writing to the database file.
poNumbers = getPOs(orderType: orderNumber);
The control-spec fixed it.
Happy computing.
Glenn Gundermann
Work: 905-501-6596
Cell: 416-317-3144
To learn more about Kuehne + Nagel Ltd, please visit our website at:
www.kuehne-nagel.com For the Kuehne + Nagel email disclaimer, visit:
http://www.kn-portal.com/material/Electronic_Email_Disclaimer_English_Fr
ench.pdf
Visitez le site internet de Kuehne + Nagel Lt?e: www.kuehne-nagel.com
Notre d?charge de responsabilit? est disponible comme suit:
http://www.kn-portal.com/material/Electronic_Email_Disclaimer_English_Fr
ench.pdf
------------------------------
message: 3
date: Fri, 15 Jan 2010 12:07:34 -0700
from: Alan Campin <alan0307d@xxxxxxxxx>
subject: Re: CPF5035 Data mapping error
Not sure what your issue is. We have a bunch of programs reading and
writing
VarChar's. We use SQL to do the processing. Are you using SQL or File
I/O?
Should be no issues reading or writing to a varchar field.
On Fri, Jan 15, 2010 at 11:49 AM, Gundermann, Glenn / Kuehne + Nagel /
Tor
ZI-A <Glenn.Gundermann@xxxxxxxxxxxxxxxx> wrote:
Hi folks,
I searched the archives and didn't find anything to help me with my
error
so now that I have figured it out, I thought I would send this in case
it
might help someone in the future.
I have a DDL-described table, and among other columns, have one
defined
as
follows:
PONUMBERS VARCHAR(760) CCSID 37 NOT NULL
I found that I needed the following control-spec in my rpg module:
h cvtopt(*novarchar)
because without this, the rpg dump listing showed that PONUMBERS was
CHAR
and not VCHAR.
So even if my getPOs procedure returns varying-length data:
D getPOs PI 760a varying
D orderType 4a const
D orderNumber 17a const
The following statement moves the returned data into a character
field,
which then causes an error when writing to the database file.
poNumbers = getPOs(orderType: orderNumber);
The control-spec fixed it.
Happy computing.
Glenn Gundermann
Work: 905-501-6596
Cell: 416-317-3144
To learn more about Kuehne + Nagel Ltd, please visit our website at:
www.kuehne-nagel.com For the Kuehne + Nagel email disclaimer, visit:
http://www.kn-portal.com/material/Electronic_Email_Disclaimer_English_Fr
ench.pdf
Visitez le site internet de Kuehne + Nagel Lt?e:
www.kuehne-nagel.comNotre d?charge de responsabilit? est disponible
comme
suit:
http://www.kn-portal.com/material/Electronic_Email_Disclaimer_English_Fr
ench.pdf
--
This is the RPG programming on the IBM i / System i (RPG400-L) mailing
list
To post a message email: RPG400-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/rpg400-l
or email: RPG400-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/rpg400-l.
------------------------------
message: 4
date: Fri, 15 Jan 2010 13:37:26 -0600
from: Loyd Goodbar <loyd@xxxxxxxxxxxxxx>
subject: Re: CPF5035 Data mapping error
I'd have to agree here. Also have SQLRPGLE programs working against
tables
with varchar columns, no issues. Using embedded SQL.
--Loyd
On Fri, Jan 15, 2010 at 1:07 PM, Alan Campin <alan0307d@xxxxxxxxx>
wrote:
Not sure what your issue is. We have a bunch of programs reading and
writing
VarChar's. We use SQL to do the processing. Are you using SQL or File
I/O?
Should be no issues reading or writing to a varchar field.
------------------------------
message: 5
date: Fri, 15 Jan 2010 15:02:24 -0500
from: Charles Wilt <charles.wilt@xxxxxxxxx>
subject: Re: CPF5035 Data mapping error
Glenn,
I'd check the defaults on CRTBNDRPG and/or CRTRPGMOD.
My system has CVTOPT(*NONE) as a default, it sounds as if yours has
CVTOPT(*VARCHAR)
HTH,
Charles
On Fri, Jan 15, 2010 at 1:49 PM, Gundermann, Glenn / Kuehne + Nagel /
Tor ZI-A <Glenn.Gundermann@xxxxxxxxxxxxxxxx> wrote:
Hi folks,
I searched the archives and didn't find anything to help me with my
error so now that I have figured it out, I thought I would send this in
case it might help someone in the future.
I have a DDL-described table, and among other columns, have one
defined
as follows:
PONUMBERS ?VARCHAR(760) CCSID 37 NOT NULL
I found that I needed the following control-spec in my rpg module:
h cvtopt(*novarchar)
because without this, the rpg dump listing showed that PONUMBERS was
CHAR and not VCHAR.
So even if my getPOs procedure returns varying-length data:
D getPOs ? ? ? ? ?PI ? ? ? ? ? 760a ? varying
D ? orderType ? ? ? ? ? ? ? ? ? ?4a ? const
D ? orderNumber ? ? ? ? ? ? ? ? 17a ? const
The following statement moves the returned data into a character
field,
which then causes an error when writing to the database file.
poNumbers = getPOs(orderType: orderNumber);
The control-spec fixed it.
Happy computing.
Glenn Gundermann
Work: 905-501-6596
Cell: 416-317-3144
To learn more about Kuehne + Nagel Ltd, please visit our website at:
www.kuehne-nagel.com For the Kuehne + Nagel email disclaimer, visit:
http://www.kn-portal.com/material/Electronic_Email_Disclaimer_English_Fr
ench.pdf
Visitez le site internet de Kuehne + Nagel Lt?e: www.kuehne-nagel.com
Notre d?charge de responsabilit? est disponible comme suit:
http://www.kn-portal.com/material/Electronic_Email_Disclaimer_English_Fr
ench.pdf
--
This is the RPG programming on the IBM i / System i (RPG400-L) mailing
list
To post a message email: RPG400-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/rpg400-l
or email: RPG400-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/rpg400-l.
------------------------------
message: 6
date: Thu, 14 Jan 2010 21:00:33 -0500
from: "Darryl Freinkel" <dfreinkel@xxxxxxxxxxxxxxxxx>
subject: C Functions missing symbols _C_sig_* on CRTPGM
I have worked through the example Scott Klement has graciously made
available. I have the examples working.
I have created a new program using Scott's template. My program binds in
a
service program that I have. The module compiles, but I am not able to
get
the program to create (CRTPGM).
I get error
Definition not found for symbol '_C_sig_dfl'
Definition not found for symbol '_C_sig_err'
Definition not found for symbol '_C_sig_ign'
Definition not found for symbol '_C_sig_err'
Without my service program, I am able to use option 14 to create.
Adding the service program then creating the module with option 15
creates.
Creating the program CRTPGM fails.
I obviously need to include more programs into my binding directory, but
I
have no idea which programs. Could someone assist with the name of the
service program to include into my binding directory.
Much appreciated.
Darryl Freinkel
Assignment 400 Group, Inc.
Tel: 770.321.8562 ext 111 | Fax 770.321.8562 | 2247 La Salle Dr,
Marietta
GA, 30062, USA | PO Box 72556, Marietta, GA 30007-2556
------------------------------
message: 7
date: Fri, 15 Jan 2010 15:45:36 -0500
from: Barbara Morris <bmorris@xxxxxxxxxx>
subject: Re: RPG overloading (was RPGV?)
Bob P. Roche wrote:
Isn't one of the features of prototyping calls that always gets
pointed
out, "the compiler checks your data to make sure you don't have a
mismatch"? If the compiler is just going to change my data to whatever
it
thinks it needs, how is that helping me not make a mistake and reverse
parms? I know it will get caught in testing, but prototyping was
supposed
to save me from this kind of mistake at compile time, unless I
specifically told it not to by using CONST.
I guess if all the parameters had slightly different types, you could
get that kind of parameter-order check.
But to ensure that check was reliable, you'd have to avoid using CONST
and VALUE and you'd have to give a slightly different data type to each
parameter. Those seem like awkward restrictions to deal with.
Prototyping was supposed to save you from making type and size mistakes
with individual parameters, but there was no particular intention that
RPG programmers would use the parameter checks to make sure the
parameters were passed in the right order.
But ... that's one of the scenarios that would have to be considered
when deciding whether there would be a new keyword or whether the
behaviour would just change.
This reminds me of a few complaints when the LR indicator was made
optional on the READ opcode. People complained that the editor didn't
forced them to code the indicator, so they also forgot to code the eof
check.
------------------------------
message: 8
date: Fri, 15 Jan 2010 15:42:58 -0600
from: Scott Klement <rpg400-l@xxxxxxxxxxxxxxxx>
subject: Re: C Functions missing symbols _C_sig_* on CRTPGM
Hi Darryl,
Are you sure you're not binding to a *MODULE object instead of a *SRVPGM
object?? I say this because a *SRVPGM has already resolved all of it's
symbols (whereas a module has not). So a *SRVPGM would not still be
looking for '_C_sig_dfl' and friends. But if you're binding a module,
it'd have to resolve these things.
As it stands, your situation doesn't really make sense. Whether or not
you bind to a *SRVPGM will have no impact on whether it can/can't
resolve symbols. (Unless you're using a totally different binding
directory of course)
Not sure if that's helpful, but maybe it'll get you on the right track.
I'll look around and see if I can find which srvpgm those particular
symbols are actually in.
Darryl Freinkel wrote:
I have worked through the example Scott Klement has graciously made
available. I have the examples working.
I have created a new program using Scott's template. My program binds
in
a
service program that I have. The module compiles, but I am not able to
get
the program to create (CRTPGM).
I get error
Definition not found for symbol '_C_sig_dfl'
Definition not found for symbol '_C_sig_err'
Definition not found for symbol '_C_sig_ign'
Definition not found for symbol '_C_sig_err'
Without my service program, I am able to use option 14 to create.
Adding the service program then creating the module with option 15
creates.
Creating the program CRTPGM fails.
I obviously need to include more programs into my binding directory,
but
I
have no idea which programs. Could someone assist with the name of the
service program to include into my binding directory.
Much appreciated.
Darryl Freinkel
Assignment 400 Group, Inc.
Tel: 770.321.8562 ext 111 | Fax 770.321.8562 | 2247 La Salle Dr,
Marietta
GA, 30062, USA | PO Box 72556, Marietta, GA 30007-2556
------------------------------
message: 9
date: Fri, 15 Jan 2010 16:48:49 -0500
from: Buck <kc2hiz@xxxxxxxxx>
subject: Re: Unit Test Frameworks for RPGLE
Bryce Martin wrote:
Does anyone know of any good unit test frameworks for the i, and any
articles and such to help out a programmer just starting out in unit
testing?
I like and use RPGUnit, but I'm easy to please in this regard. What do
you think is missing? Since we have the source code we can add what we
need (if the developer has abandoned the project.)
I know of no open source projects. There are several vendors who offer
a more complete testing suite - extracting database elements and the
like. Unfortunately, I never had the funding to purchase one and I
apologise to the kind souls who tried to help me in the past but I don't
recall any names :-(
--buck
------------------------------
message: 10
date: Fri, 15 Jan 2010 15:49:58 -0600
from: Scott Klement <rpg400-l@xxxxxxxxxxxxxxxx>
subject: Re: C Functions missing symbols _C_sig_* on CRTPGM
Those symbols are found in the QC2UTIL1 service program (IBM-supplied).
The proper way to bind to it is to bind to the QC2LE binding directory.
I don't recommend adding QC2UTIL1 to your own binding directory.
However (again), whether you bind to another *SRVPGM or not should have
no impact on whether it can find these symbols. More likely you're
binding to a *MODULE that uses these symbols (and therefore they have to
be resolved) or your code uses these symbols directly, and you've
failed to bind to QC2LE.
A *SRVPGM that uses these symbols would nto have this problem, since it
would've been resolved when the *SRVPGM was built.
Scott Klement wrote:
I get error
Definition not found for symbol '_C_sig_dfl'
Definition not found for symbol '_C_sig_err'
Definition not found for symbol '_C_sig_ign'
Definition not found for symbol '_C_sig_err'
------------------------------
midrange.com
