RE: trouble making ADDRDBDIRE work

Sorry Charly,

:)

No can do.... Only one *LOCAL entry on a machine. Perhaps if you LPAR....
>From help text:

                  Remote location (RMTLOCNAME) - Help

Specifies the remote location name of the system on which the relational
database is located.

This is a required parameter.

The possible values are:

*LOCAL
    The relational database is located on this system.  You can specify
    *LOCAL for only one entry in the relational database directory since
    there is only one database on this system.



Eric DeLong
Sally Beauty Company
MIS-Sr. Programmer/Analyst
940-898-7863 or ext. 1863



-----Original Message-----
From: Charly Jones [mailto:charly301@hotmail.com]
Sent: Friday, February 08, 2002 11:37 AM
To: midrange-l@midrange.com
Subject: trouble making ADDRDBDIRE work



I would like to create two relational database directory entries for the
*LOCAL system.  Since I can ping the local system, shouldn't I be able to
create a RDB directory entry using the local IP in addition to the *LOCAL?

But my immediate problem is that I can't make a new RDB directory entry that
I can CONNECT to with SQL.  There must be something I don't know about how
this works...

I added a RDB directory entry.  I try to CONNECT to it in SQL, and I get a
"Relational database VSI19 not found"  What gives?  Does anyone know?

Thanks for your help,

-- Charly

Gig Harbor WA 98335 USA
253 265-6244

+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

A long habit of not thinking a thing wrong gives it a superficial
appearance of being right, and raises, at first, a formidable
outcry in defense of custom.
                                        -- Tom Paine

In personal conversations with technical people, I call myself
a hacker. But when I'm talking to journalists I just say
"programmer" or something like that.
                                        -- Linus Torvalds

+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++





                     Add RDB Directory Entry (ADDRDBDIRE)

Type choices, press Enter.

Relational database  . . . . . . > TEST18
Remote location:
  Name or address  . . . . . . . > '9.5.2.31'

Type . . . . . . . . . . . . . > *IP
Text . . . . . . . . . . . . . . > 'relational data base at TEST18'

Port number or service program     *DRDA

               Work with Relational Database Directory Entries

Position to  . . . . . .

Type options, press Enter.
  1=Add   2=Change   4=Remove   5=Display details   6=Print details

        Relational          Remote
Option  Database            Location                  Text

        MITHRA              *LOCAL                    Entry added by system
        TEST18              9.5.2.31                  relational data base
at local TEST18

STRSQL

CONNECT TO TEST18 USER CJONES USING 'SECRETPASSWORD'
Relational database TEST18 not found.






_________________________________________________________________
Chat with friends online, try MSN Messenger: http://messenger.msn.com

_______________________________________________
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.