Re: Checking for Empty File

I'm sure I should know this, but I can not seem to find any information
one way or another...is there a way to check if a file is empty in CL?
I need to FTP mutliple files, but do NOT want to FTP a file if it is
empty.

Thanks for any help.

Elonna



midrange-l-request@xxxxxxxxxxxx
Sent by: midrange-l-bounces@xxxxxxxxxxxx
08/14/2008 10:10 AM
Please respond to
midrange-l@xxxxxxxxxxxx


To
midrange-l@xxxxxxxxxxxx
cc

Subject
MIDRANGE-L Digest, Vol 7, Issue 1621






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: SQL: SELECT from flat-file returns data in hex... (CRPence)
2. RE: What versions of Linux are IBM supported on a dedicated,
non hosted, lpar on a 9406-MMA? (Ingvaldson, Scott)
3. RE: Client Access and Windows Vista (Steve Dodkins)
4. Re: booting JS12 ibm i from virtual media (Lukas Beeler)
5. FileZilla and the iSeries (Reger, Bill)
6. Re: SQL: SELECT from flat-file returns data in hex...
(Michael Rosinger)
7. Re: Client Access and Windows Vista (Lukas Beeler)
8. Database character fields (Mike Cunningham)
9. Re: FileZilla and the iSeries (David Gibbs)


----------------------------------------------------------------------

message: 1
date: Thu, 14 Aug 2008 08:07:12 -0500
from: CRPence <CRPbottle@xxxxxxxxx>
subject: Re: SQL: SELECT from flat-file returns data in hex...

It is an attribute of the connection. A "Force translation" checkbox
or something like that. However if you know the CCSID of the data, you
could request instead of SUBSTR(F00001, 11, 10) to get the untagged
data, request the tagged data with CAST(SUBSTR(F00001, 11, 10) AS
CHAR(10) CCSID 37)

Regards, Chuck

Michael Rosinger wrote:

In Run SQL Scripts of iNav, when I execute a SELECT against a
"flat-file", the data is returned in hex instead of character format.

Some time ago there was a mention in a thread of a command that could
be issued that would solve this problem for any subsequent queries
against files of that nature. I remember trying it and it worked
great, but for the life of me I can't remember what the command was.
I've tried CL:CHGJOB CCSID(37); but that doesn't do it.

Please remind me what that command was. TIA

------------------------------

message: 2
date: Thu, 14 Aug 2008 08:26:57 -0500
from: "Ingvaldson, Scott" <scott.ingvaldson@xxxxxxxxxx>
subject: RE: What versions of Linux are IBM supported on a dedicated,
non hosted, lpar on a 9406-MMA?

How about
http://publib.boulder.ibm.com/infocenter/systems/scope/hw/index.jsp?topi
c=/iphc5/9406_MMA_landing.htm

Under Installing Linux?

Regards,

Scott Ingvaldson
Senior IBM Support Specialist
Fiserv Midwest


-----Original Message-----
From: rob@xxxxxxxxx [mailto:rob@xxxxxxxxx]
Sent: Wednesday, August 13, 2008 3:25 PM
To: Midrange Systems Technical Discussion
Subject: RE: What versions of Linux are IBM supported on a dedicated,non
hosted, lpar on a 9406-MMA?

No mention of M25, or MMA.
Minimal to no mention of which service pack.

Rob Berendt
--
Group Dekko Services, LLC
Dept 01.073
Dock 108
6928N 400E
Kendallville, IN 46755
http://www.dekko.com





"Ingvaldson, Scott" <scott.ingvaldson@xxxxxxxxxx>
Sent by: midrange-l-bounces@xxxxxxxxxxxx
08/13/2008 02:17 PM
Please respond to
Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxx>


To
"Midrange Systems Technical Discussion" <midrange-l@xxxxxxxxxxxx>
cc

Subject
RE: What versions of Linux are IBM supported on a dedicated, non
hosted, lpar on a 9406-MMA?






See: http://www-03.ibm.com/systems/i/os/linux/dist.html

Regards,

Scott Ingvaldson
Senior IBM Support Specialist
Fiserv Midwest


-----Original Message-----
From: rob@xxxxxxxxx [mailto:rob@xxxxxxxxx]
Sent: Wednesday, August 13, 2008 12:03 PM
To: midrange-l@xxxxxxxxxxxx
Subject: What versions of Linux are IBM supported on a dedicated, non
hosted, lpar on a 9406-MMA?

What versions of Linux are IBM supported on a dedicated, non hosted,
lpar on a 9406-MMA?
rtfm links appreciated.

Rob Berendt
--
Group Dekko Services, LLC
Dept 01.073
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: 3
date: Thu, 14 Aug 2008 14:24:51 +0100
from: "Steve Dodkins" <Steve.Dodkins@xxxxxxxxxxxxxxx>
subject: RE: Client Access and Windows Vista

I had to get 5.8 to use on Vista although our AS400 is still on 5.2. An
issue we have is that you cannot map a drive to V5R2 from our Vista
machines.



-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx
[mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Bob O.
Sent: 14 August 2008 13:53
To: Midrange Systems Technical Discussion
Subject: RE: Client Access and Windows Vista



On my PC, it says I'm at Version 5, Release 4, Modification Level 0,
Service Level SI20465. This is a Windows XP Box though.

From: otis_the_cat@xxxxxxxxxxx> To: midrange-l@xxxxxxxxxxxx> Subject:

Client Access and Windows Vista> Date: Wed, 13 Aug 2008 10:32:26 -0500>

> We are going to be getting some Vista PC's pretty soon and I was

wondering about issues with running client access on them. I looked in
the archives and the posts there seem to be kind of old so I figured I'd
put in a new post for more current information.> > My main question is;
What should I make sure about iSeries-wise as to being confident that
Client Access will run (and work) on the Vista machines?> > Most of our
PC's are using "Version 5.8 for Windows" (found under Help/About
Personal Communications". Is there a more current version of iSeries
Access that is needed to run on Windows Vista? What about PTF's?>
_________________________________________________________________> Your
PC, mobile phone, and online services work together like never before.>
http://clk.atdmt.com/MRT/go/108587394/direct/01/> -- > This is the
Midrang!
e 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.>
_________________________________________________________________
Reveal your inner athlete and share it with friends on Windows Live.
http://revealyourinnerathlete.windowslive.com?locale=en-us&ocid=TXT_TAGL
M_WLYIA_whichathlete_us
--
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 email has been scanned by the MessageLabs Email Security System.
For more information please visit http://www.messagelabs.com/email
______________________________________________________________________

______________________________________________________________________
This email has been scanned by the MessageLabs Email Security System.
For more information please visit http://www.messagelabs.com/email
______________________________________________________________________


------------------------------

message: 4
date: Thu, 14 Aug 2008 15:34:17 +0200
from: "Lukas Beeler" <lukas.beeler@xxxxxxxxxxxxxxxx>
subject: Re: booting JS12 ibm i from virtual media

On Thu, Aug 14, 2008 at 2:41 PM, Steve Richter <stephenrichter@xxxxxxxxx>
wrote:

I finally got my install to work. The final crazy error was a reported
hardware failure when I tried to activate the i5/os partition from the
install media. A long time on the phone with IBM blade hardware
support and then Rochester i5/OS install support, it turned out I had
mistakenly inserted the 2nd and not the 1st IBM i install DVD. never
mind, sorry!

Ah well, it's running now. That's all that matters.

I thought the install was relatively quick. The process of
initializing the system, adding drives to the ASP, loading the LIC and
OS was 2x faster than doing the same on my 460CPW 170. The BCS is a
very sporty piece of hardware. Not too noisy ( esp if the room is cool
) and so far does not use much electricity.

My comparison was to a 515 with 4 arms in a RAID5 configuration. On my
system, initializing the disks took ages (multiple hours). Maybe
something was already fixed in the firmware revisions you received,
because the performance i had can't be normal.

--
Read my blog at http://projectdream.org


------------------------------

message: 5
date: Thu, 14 Aug 2008 09:49:24 -0400
from: "Reger, Bill" <BillR@xxxxxxxxxxxxxx>
subject: FileZilla and the iSeries

I really like FileZilla. It's easy to use, intuitve, and free. All good.
But I'm having difficulties using it with the iSeries (AS/400, I5,
whatever it's called these days). I've seen posts here where people seem
to be FTPing to and from the iSeries with FileZilla just fine. Are there
some tricks or commands or something that I'm not doing right?

Bill


------------------------------

message: 6
date: Thu, 14 Aug 2008 09:53:46 -0400
from: "Michael Rosinger" <mrosinger@xxxxxxxxx>
subject: Re: SQL: SELECT from flat-file returns data in hex...

Chuck,

That was it! In Run SQL Scripts, from the menu: Connection | JDBC Setup,
on
the Translation tab there is "Translate CCSID 65535" checkbox. It was
unchecked. I had it previously checked but I just installed the latest
iSeries Access for Windows fixpack and that must have overridden my
setting.
With that checked the data is returned as character data.

Thanks for jogging my memory!

--
Regards,

Michael Rosinger
Systems Programmer / DBA
Computer Credit, Inc.
640 West Fourth Street
Winston-Salem, NC 27101
336-761-1524
m rosinger at cciws dot com
"CRPence" <CRPbottle@xxxxxxxxx> wrote in message
news:mailman.3791.1218719199.2545.midrange-l@xxxxxxxxxxxxxxx

It is an attribute of the connection. A "Force translation" checkbox

or

something like that. However if you know the CCSID of the data, you

could

request instead of SUBSTR(F00001, 11, 10) to get the untagged data,
request the tagged data with CAST(SUBSTR(F00001, 11, 10) AS CHAR(10)

CCSID

37)

Regards, Chuck

Michael Rosinger wrote:

In Run SQL Scripts of iNav, when I execute a SELECT against a
"flat-file", the data is returned in hex instead of character format.

Some time ago there was a mention in a thread of a command that could
be issued that would solve this problem for any subsequent queries
against files of that nature. I remember trying it and it worked
great, but for the life of me I can't remember what the command was.
I've tried CL:CHGJOB CCSID(37); but that doesn't do it.

Please remind me what that command was. TIA

------------------------------

message: 7
date: Thu, 14 Aug 2008 15:56:45 +0200
from: "Lukas Beeler" <lukas.beeler@xxxxxxxxxxxxxxxx>
subject: Re: Client Access and Windows Vista

On Thu, Aug 14, 2008 at 3:24 PM, Steve Dodkins
<Steve.Dodkins@xxxxxxxxxxxxxxx> wrote:

I had to get 5.8 to use on Vista although our AS400 is still on 5.2. An

Support for V5R2 expired ages ago! Upgrade now!

--
Read my blog at http://projectdream.org


------------------------------

message: 8
date: Thu, 14 Aug 2008 10:01:06 -0400
from: Mike Cunningham <mcunning@xxxxxxx>
subject: Database character fields

Not looking to start a war over which is better, just looking to update my
knowledge.

When we create character fields in DB2/400 we usually setup fixed length,
no null support fields. If the character fields is long (e.g. 100+ bytes)
and we suspect the data will vary greatly in actually used length, we will
make it a variable length field. The only time we use null fields is for
data we are importing in from other systems where the file can have null
values. In those cases the file with null field support is usually a work
file used for the import and they we move the data into non-null fields in
the production files. In other databases (like MS SQL) the standard looks
like it is just the opposite. All character fields are variable length
with null support unless you take extra steps to not do that. My training
(and it has been some years) said that variable length fields are good for
saving storage space but bad for overhead. That the database had to do
extra work to manage the variable length, tracking the actually number of
bytes in use and manage the ov!
erflow areas when the data in the fields changed from 10 characters to
1,000 and back to 10. Is it still true that variable length fields are
less efficient and if so why do other databases have that as the default?
Or is this something specific to the implementation of the database? Is
DB2/400 move efficient with fixed length but MS SQL more efficient with
variable length?


------------------------------

message: 9
date: Thu, 14 Aug 2008 09:02:41 -0500
from: David Gibbs <david@xxxxxxxxxxxx>
subject: Re: FileZilla and the iSeries

Reger, Bill wrote:

I really like FileZilla. It's easy to use, intuitve, and free. All
good. But I'm having difficulties using it with the iSeries (AS/400,
I5, whatever it's called these days). I've seen posts here where
people seem to be FTPing to and from the iSeries with FileZilla just
fine. Are there some tricks or commands or something that I'm not
doing right?

I find it works OK if you set the default remote directory to '/' so it
immediately switches to namefmt 1 (a more unixy format). I don't think it
works if the name format is 0 (native i/os format).

david



--
IBM i on Power - For when you can't afford to be out of business


------------------------------

--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) digest 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.



End of MIDRANGE-L Digest, Vol 7, Issue 1621
*******************************************



CONFIDENTIALITY NOTICE: This electronic message is intended to
be viewed only by the individual or entity to whom it is
addressed. It may contain information that is privileged,
confidential and exempt from disclosure under applicable law.
Any dissemination, distribution or copying of this
communication is strictly prohibited without our prior
permission. If the reader of this message is not the intended
recipient, or the employee or agent responsible for delivering
the message to the intended recipient, or if you have received
this communication in error, please notify us immediately by
return e-mail and delete the original message and any copies of
it from your computer system.
--
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.