|
Evan, I thank you for your respnse, and will try to clarify the issues below. We appreciate all of your patience with my attempts to reiterate this problem we are having. 1. We have 2 iSeries - both on V5R4. One is local, one remote. Also we have a remote tape drive. 2. We must backup an iSeries in Timbuktu. That system does NOT have enough disk space to backup all user data to virtual tape. 3. We can create a tape in Timbuktu but we can't pick it up or have it delivered. 4. We thought we might backup Timbuktu to a physical tape and then copy that Timbuktu physical tape one file at a time to a small virtual tape that could be sent to a backup iSeries that is offsite from Timbuktu. 5. Our stumbling blocks are that we are short on disk space - and approval to purchase additional will not occur at theis time. We have enough for production purposes only. 6. Our remote iSeries and tape drive are virtually non-accessible. -----Original Message----- From: midrange-l-request@xxxxxxxxxxxx [mailto:midrange-l-request@xxxxxxxxxxxx] Sent: Monday, March 12, 2007 3:26 PM To: midrange-l@xxxxxxxxxxxx Subject: MIDRANGE-L Digest, Vol 6, Issue 552 Send MIDRANGE-L mailing list submissions to midrange-l@xxxxxxxxxxxx To subscribe or unsubscribe via the World Wide Web, visit http://lists.midrange.com/mailman/listinfo/midrange-l or, via email, send a message with subject or body 'help' to midrange-l-request@xxxxxxxxxxxx You can reach the person managing the list at midrange-l-owner@xxxxxxxxxxxx When replying, please edit your Subject line so it is more specific than "Re: Contents of MIDRANGE-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: How did DST go for you. (Al Barsa) 2. RE: CREATE TABLE as sub-query with primary key syntax (DeLong, Eric) 3. Re: Zebra 110xi - as a print device (Jim Franz) 4. Re: How did DST go for you. (rob@xxxxxxxxx) 5. Re: iSeries educational plan with our local University (Dan) 6. RE: Zebra 110xi - as a print device (George Kinney) 7. RE: physical / virtual tape backup file at a time (Evan Harris) 8. RE: Zebra 110xi - as a print device (Jeff Crosby) ---------------------------------------------------------------------- message: 1 date: Mon, 12 Mar 2007 14:33:34 -0400 from: Al Barsa <barsa@xxxxxxxxxxxxxxxxxxx> subject: RE: How did DST go for you. We are! Al Al Barsa, Jr. Barsa Consulting Group, LLC 400>390 "i" comes before "p", "x" and "z" e gads Our system's had more names than Elizabeth Taylor! 914-251-1234 914-251-9406 fax http://www.barsaconsulting.com http://www.taatool.com http://www.as400connection.com rob@xxxxxxxxx Sent by: midrange-l-bounce To s@xxxxxxxxxxxx Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxx> 03/12/2007 12:47 cc PM Subject RE: How did DST go for you. Please respond to Midrange Systems Technical Discussion <midrange-l@midra nge.com> Anyone using Timezone QN0500EST3 ? Rob Berendt -- Group Dekko Services, LLC Dept 01.073 PO Box 2000 Dock 108 6928N 400E Kendallville, IN 46755 http://www.dekko.com -- This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list To post a message email: MIDRANGE-L@xxxxxxxxxxxx To subscribe, unsubscribe, or change list options, visit: http://lists.midrange.com/mailman/listinfo/midrange-l or email: MIDRANGE-L-request@xxxxxxxxxxxx Before posting, please take a moment to review the archives at http://archive.midrange.com/midrange-l. ------------------------------ message: 2 date: Mon, 12 Mar 2007 13:35:20 -0500 from: "DeLong, Eric" <EDeLong@xxxxxxxxxxxxxxx> subject: RE: CREATE TABLE as sub-query with primary key syntax I think you forgot to put the ending paren on the select clause.... CREATE TABLE TEMP AS ( SELECT DBIFIL, DBIFMT, DBIFLD, DBIUPD FROM QSYS/QADBIFLD WHERE DBIFIL = "TEST") -- Added paren PRIMARY KEY(DBIFIL, DBIFMT, DBIFLD) WITH DATA; -----Original Message----- From: midrange-l-bounces@xxxxxxxxxxxx [mailto:midrange-l-bounces@xxxxxxxxxxxx]On Behalf Of Peter Dow (ML) Sent: Monday, March 12, 2007 1:24 PM To: Midrange Systems Technical Discussion Subject: CREATE TABLE as sub-query with primary key syntax I'm trying to create a table with this by putting the following into a source member and using RUNSQLSTM: CREATE TABLE TEMP AS ( SELECT DBIFIL, DBIFMT, DBIFLD, DBIUPD FROM QSYS/QADBIFLD WHERE DBIFIL = "TEST" PRIMARY KEY(DBIFIL, DBIFMT, DBIFLD) WITH DATA; It doesn't like the PRIMARY KEY() clause. I checked the v5r3 SQL manual, and it doesn't give any examples of doing it, but has the following to say under the "as sub-query" heading of the CREATE TABLE command: "The implicit definition does not include any other optional attributes of the identified table or view. For example, the new table does not automatically include a primary key or foreign key from a table. The new table has these and other optional attributes only if the optional clauses are explicitly specified." which to me implies that I can use the PRIMARY KEY clause, I just don't have the syntax right. Does anyone know the correct syntax, or whether this is allowed or not? *Peter Dow* / Dow Software Services, Inc. 909 793-9050 pdow@xxxxxxxxxxxxxxx <mailto:pdow@xxxxxxxxxxxxxxx> / -- This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list To post a message email: MIDRANGE-L@xxxxxxxxxxxx To subscribe, unsubscribe, or change list options, visit: http://lists.midrange.com/mailman/listinfo/midrange-l or email: MIDRANGE-L-request@xxxxxxxxxxxx Before posting, please take a moment to review the archives at http://archive.midrange.com/midrange-l. ------------------------------ message: 3 date: Mon, 12 Mar 2007 14:34:21 -0400 from: "Jim Franz" <franz400@xxxxxxxxxxxx> subject: Re: Zebra 110xi - as a print device Mine is connected via a Jet Direct (printer is parrallel) According to the knowkedge base - this is required-Workstation customizing object . . . . : QWPDEFAULT Queue: M8 Library: QUSRSYS Authority to check . . . . . . . . . . : *OWNER Remote system . . . . . . . . . . . . : *INTNETADR Remote printer queue . . . . . . . . . : text Queue for writer messages . . . . . . : QSYSOPR Library . . . . . . . . . . . . . . : *LIBL Connection type . . . . . . . . . . . : *IP Internet address . . . . . . . . . . . : 10.0.1.199 Destination type . . . . . . . . . . . : *OTHER Host print transform . . . . . . . . . : *YES Manufacturer type and model . . . . . : *HP4 Workstation customizing object . . . . : QWPDEFAULT Library . . . . . . . . . . . . . . : *LIBL Image configuration . . . . . . . . . : *NONE Destination options . . . . . . . . . : *NONE Print separator page . . . . . . . . . : *NO User defined option . . . . . . . . . : *NONE User defined object: Object . . . . . . . . . . . . . . . : *NONE Library . . . . . . . . . . . . . : Object type . . . . . . . . . . . . : User driver program . . . . . . . . . : *NONE Library . . . . . . . . . . . . . . : jim franz ----- Original Message ----- From: "Jeff Crosby" <jlcrosby@xxxxxxxxxxxxxxxx> To: "'Midrange Systems Technical Discussion'" <midrange-l@xxxxxxxxxxxx> Sent: Monday, March 12, 2007 2:19 PM Subject: RE: Zebra 110xi - as a print device
Well, somehow I'm just born with luck, I guess. I have been working with Zebra support for 3 business days now. So far, not only have they not been able to tell me how to set up the 110Xi Plus as a print device, they can't even tell me how to set it up as a remote outq. Can someone post their remote outq setup here so I can at least
determine
the printer works with an i5 in any fashion? Thanks. -- Jeff Crosby Dilgard Frozen Foods, Inc. P.O. Box 13369 Ft. Wayne, IN 46868-3369 260-422-7531 The opinions expressed are my own and not necessarily the opinion of
my
company. Unless I say so.-----Original Message----- From: midrange-l-bounces@xxxxxxxxxxxx [mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Jeff Crosby Sent: Friday, March 09, 2007 12:32 PM To: 'Midrange Systems Technical Discussion' Subject: Zebra 110xi - as a print device All, We're attempting to demo a Zebra 110xi label printer. The reseller (and Zebra literature) tells me it can be set up on the i5 as either a remote outqueue or a print device. I want it set up as a print device and so far cannot find the person within Zebra to tell me how to do this. I see a number of posts here indicating it's use as a remote outqueue, but I'm looking for an actual instance where it's used as a print device. Thanks for any help. -- Jeff Crosby Dilgard Frozen Foods, Inc. P.O. Box 13369 Ft. Wayne, IN 46868-3369 260-422-7531 The opinions expressed are my own and not necessarily the opinion of my company. Unless I say so. -- This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list To post a message email: MIDRANGE-L@xxxxxxxxxxxx To subscribe, unsubscribe, or change list options, visit: http://lists.midrange.com/mailman/listinfo/midrange-l or email: MIDRANGE-L-request@xxxxxxxxxxxx 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@xxxxxxxxxxxx To subscribe, unsubscribe, or change list options, visit: http://lists.midrange.com/mailman/listinfo/midrange-l or email: MIDRANGE-L-request@xxxxxxxxxxxx Before posting, please take a moment to review the archives at http://archive.midrange.com/midrange-l.
------------------------------ message: 4 date: Mon, 12 Mar 2007 14:38:08 -0400 from: rob@xxxxxxxxx subject: Re: How did DST go for you. We had the change last year also for the first time here in Indiana. I am of Al Barsa's opinion. Why create a new timezone? Why not just change the dates on the existing timezone with the ptf's? But I guess the reason is that not all regions that were using the old one are now using the new one. Hard to fathom that not all of our neighbors south of our border bow to the "Colossus of the North". :-) Rob Berendt
As an Amazon Associate we earn from qualifying purchases.
This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.