× The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.


  1.  Home
  2. MIDRANGE-L
  3. March 2007

RE: physical / virtual tape backup file at a time

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 thread ...
Follow-Ups:
Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

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.