Re: strsql Question

["R. Bruce Hoffman, Jr." <rbruceh@xxxxxxxxxxxxx>]

it's not you, but I am laughing, i just take this stuff for granted and like
AS400 commands, I just key the statement and it happens.... guess i'm just
jaded...

in sql...

CREATE ALIAS schema.table FOR library.file (member)

if your naming convention in sql is system, then the period becomes a slash

===========================================================
R. Bruce Hoffman, Jr.
 -- IBM Certified Specialist - AS/400 Administrator
 -- IBM Certified Specialist - RPG IV Developer

"America is the land that fought for freedom and then
  began passing laws to get rid of it."

     - Alfred E. Neuman

-----Original Message-----
From: Bill Erhardt <ERHARDT@BaldwinHQ.com>
To: 'midrange-l@midrange.com' <midrange-l@midrange.com>
Date: Wednesday, October 03, 2001 7:33 AM
Subject: RE: strsql Question


>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 ]
>Ok, how do you create an alias?
>
>> -----Original Message-----
>> From: R. Bruce Hoffman, Jr. [SMTP:rbruceh@attglobal.net]
>> Sent: Tuesday, October 02, 2001 7:20 PM
>> To: midrange-l@midrange.com
>> Subject: Re: strsql auestion
>>
>> two ways, you do an override to a member before invoking STRSQL (not
>> convienient)
>>
>> or you create an alias in sql for the member
>>
>>
>> ===========================================================
>> R. Bruce Hoffman, Jr.
>>  -- IBM Certified Specialist - AS/400 Administrator
>>  -- IBM Certified Specialist - RPG IV Developer
>>
>> "America is the land that fought for freedom and then
>>   began passing laws to get rid of it."
>>
>>      - Alfred E. Neuman
>>
>> -----Original Message-----
>> From: Hatzenbeler, Tim <thatzenbeler@clinitech.net>
>> To: 'midrange-l@midrange.com' <midrange-l@midrange.com>
>> Date: Tuesday, October 02, 2001 6:38 PM
>> Subject: strsql auestion
>>
>>
>> >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 ]
>> >
>> >
>> >Is there a file/library(member) convention for interactive sql's?
>> >ie:  select * from lib/file(member)
>> >
>> >the lib/file works... but the member doesn't...  But since the client
>> access
>> >xfer option allows members... I figured there must be a way...  unless
it
>> >does the override in the background..
>> >
>> >tim
>> >_______________________________________________
>> >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.
>--
>
>
>_______________________________________________
>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.
>