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
midrange.com
