RE: generate DDS from SQL table?

[rob@xxxxxxxxx]

This is a multipart message in MIME format.
--
[ Picked text/plain from multipart/alternative ]
This is the one we need HELP on.  The other ones are blatantly DBU's
responsibility to fix.  However this one may explain why DBU took the
'road less travelled'.
Buffer length longer than record for member "By_Name".


Rob Berendt
--
"They that can give up essential liberty to obtain a little temporary
safety deserve neither liberty nor safety."
Benjamin Franklin




"Hatzenbeler, Tim" <thatzenbeler@clinitech.net>
Sent by: midrange-l-admin@midrange.com
04/23/2002 02:58 PM
Please respond to midrange-l


        To:     "'midrange-l@midrange.com'" <midrange-l@midrange.com>
        cc:
        Fax to:
        Subject:        RE: generate DDS from SQL table?


This message is in MIME format. Since your mail reader does not understand
this format, some or all of this message may not be legible.
--
[ Picked text/plain from multipart/alternative ]
No I don't... But I called DBU and they told me 6.0 should fix the
problem... But I'm going on vacation next week, and the last thing I want
to
do is add a new variable to our system before I leave....

But when I get back, I'll try it...

But the error I received was:

                         Additional Message Information



 Message ID . . . . . . :   RPG0211       Severity . . . . . . . :   99

 Message type . . . . . :   Inquiry

 Date sent  . . . . . . :   04/23/02      Time sent  . . . . . . :
10:30:01


 Message . . . . :   Error calling program DBU0091 (C G S D F).

 Cause . . . . . :   The RPG program DBU0125 in library DBU50 at statement

   43000 attempted to call program DBU0091, but was unable to find program

   DBU0091, its library, or one of its service programs.  Check the joblog
for
   more information on the cause of the error.

 Recovery  . . . :   Enter C to cancel, G to continue processing at
*GETIN,
S
   to obtain a system dump, or D to obtain an RPG formatted dump.

 Possible choices for replying to message . . . . . . . . . . . . . . . :

   D -- Obtain RPG formatted dump.

   S -- Obtain system dump.

   G -- Continue processing at *GETIN.

   C -- Cancel.


More...
****************************************************************************
************************
                              Display All Messages

                                                             System:
EVCLFIN
 Job . . :   TEST5         User . . :   TIMH          Number . . . :
595484


  >> dbu by_name

     Data area DBUFIL exists in QTEMP.

     Buffer length longer than record for member "By_Name".

     Cannot resolve to object DBU0091. Type and Subtype X'0201' Authority

       X'0000'.

     Error calling program DBU0091 (C G S D F).

     Error calling program DBU0091 (C G S D F).



                         Additional Message Information



 Message ID . . . . . . :   MCH3401       Severity . . . . . . . :   40

 Message type . . . . . :   Escape

 Date sent  . . . . . . :   04/23/02      Time sent  . . . . . . :
10:30:01


 Message . . . . :   Cannot resolve to object DBU0091. Type and Subtype
X'0201'
   Authority X'0000'.

 Cause . . . . . :   Either a system pointer or a data pointer can not be

   resolved.

     For a system pointer, it can not be resolved to object DBU0091, type
and
   subtype X'0201', authorization X'0000', because either the named object
was
   not in any context referred to or the correct object was located but
the

   user profile did not have the required authority.

     The object types for common type or subtype codes follow:

     -- 0100-Access group, 0201-Program, 0401-Library,

     -- 0701-Journal receiver, 0801-User profile, 0901-Journal,

     -- 0B90-Data space, 0C90-Data space index, 0D50-Data base file
member,


More...










> -----Original Message-----
> From:          Vernon Hamberg [SMTP:vhamberg@attbi.com]
> Sent:          Tuesday, April 23, 2002 12:13 PM
> To:            midrange-l@midrange.com
> Subject:               RE: generate DDS from SQL table?
>
> Do you have the most recent version of DBU? I would think it'd know how
to
> deal with SQL tables.
>
> You might DSPFFD the table and see what you get.
>
> At 11:49 AM 4/23/02 -0700, you wrote:
> >This message is in MIME format. Since your mail reader does not
> understand
> >this format, some or all of this message may not be legible.
> >--
> >[ Picked text/plain from multipart/alternative ]
> >I told access (m$) to export a table to the as/400 via ODBC, and it
> created
> >a table in the as/400.  But when I tried to DBU the file, DBU
complained
> >about changing the data in the table... So I thought if I could created
a
> >DDS file from this table, I could then generate a Pysical file, and
move
> the
> >data into that file, and see if the error went away.
>
> _______________________________________________
> This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing
> list
> To post a message email: MIDRANGE-L@midrange.com
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/cgi-bin/listinfo/midrange-l
> or email: MIDRANGE-L-request@midrange.com
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/midrange-l.
_______________________________________________
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing
list
To post a message email: MIDRANGE-L@midrange.com
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/cgi-bin/listinfo/midrange-l
or email: MIDRANGE-L-request@midrange.com
Before posting, please take a moment to review the archives
at http://archive.midrange.com/midrange-l.