× 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. January 2009

RE: ftp quote rcmd SBMJOB

But jobq qsysnomax on hold, run the FTP again, and see if there's a job
there. Most likely it did work. I use FTP to run remote commands all the
time on my 515. Even to shut it off when the UPS (connected to my PC) says
power went out.



Bradley V. Stone
BVSTools - www.bvstools.com
eRPG SDK - www.erpgsdk.com

-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx
[mailto:midrange-l-bounces@xxxxxxxxxxxx]On Behalf Of Gary Monnier
Sent: Saturday, January 17, 2009 10:46 AM
To: midrange-l@xxxxxxxxxxxx
Subject: RE: ftp quote rcmd SBMJOB


The submit may well be completing successfully. The call, performed from
within the submitted job, however might not. Does program RSTPRDT2 reside
in the library list of the submitted job? Do you know what job
description
is being used for the submit?


-----Original Message-----

date: Sat, 17 Jan 2009 12:44:25 +1300
from: "Evan Harris" <spanner@xxxxxxxxxx>
subject: RE: ftp quote rcmd SBMJOB

Hi Jerry

Does the history log show the job starting at that time ?

Is the FTP user set up with LMTCPB(*NO) ?

You might want to try another jobqueue and hold it so you can
track the job
through from start to end while you are debugging the process.

Regards
Evan Harris

-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx
[mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Jerry Draper
Sent: Saturday, 17 January 2009 12:13 p.m.
To: Midrange Systems Technical Discussion
Subject: ftp quote rcmd SBMJOB

Can I do this?

ftp2sys ftp2sys
binary

put PRDT2SF

quote rcmd SBMJOB CMD(CALL PGM(RSTPRDT2)) JOB(RSTPRDT2) JOBQ(QSYSNOMAX)
quit

I tried it and there is no trace that anything happened on the remote.

The ftp output is:

331 Enter password.
230 FTP2SYS logged on.
OS/400 is the remote operating system. The TCP/IP version is "V5R4M0".
250 Now using naming format "0".
257 "QGPL" is current library.
Enter an FTP subcommand.
> binary
200 Representation type is binary IMAGE.
Enter an FTP subcommand.
> quote rcmd SBMJOB CMD(CALL PGM(RSTPRDT2)) JOB(RSTPRDT2)
JOBQ(QSYSNOMAX)
250 Command SBMJOB CMD(CALL PGM(RSTPRDT2)) JOB(RSTPRDT2)
JOBQ(QSYSNOMAX) successful.



--
Jerome Draper, Trilobyte Software Systems, since 1976
iSeries, Network, and Connectivity Specialists -- iSeries, LAN/WAN/VPN
Representing WinTronix, Synapse, Netopia, HiT, and others .....
(415) 457-3431; www.trilosoft.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: 6
date: Fri, 16 Jan 2009 15:59:36 -0800
from: "Chris Bipes" <chris.bipes@xxxxxxxxxxxxxxx>
subject: RE: Load Source Migration

We are running V5R3 and it did not let me *ENDALC on the load source.
But that may be do to the fact I am very tight on room. There may not
be enough free space to move all the data from 8 drives. So I have 7
*ENDALC and started the *MOVDTA already. More to follow tomorrow Night,
late.


Chris Bipes
Director of Information Services
CrossCheck, Inc.


-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx
[mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Evan Harris
Sent: Friday, January 16, 2009 3:21 PM
To: 'Midrange Systems Technical Discussion'
Subject: RE: Load Source Migration

Hi Chris

I'd allow an hour or so for the migrate, but it will probably take less
than that - depends on the controller more than anything else in my
experience.

You can *ENDALC on the load source drive - from what I understand you'll
end up with just the LIC on there. I had an IBM engineer tell me this
was OK.

As to the Load source migration, will you physically relocate the drive
after it is migrated ? If not, is the position of the disk you are
migrating to a valid Load Source position ? I've had the Load Source
position bite me at least once on a 520 migration.

Hope this helps. It always pays to have a good book handy when working
with disks.

Regards
Evan Harris


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

message: 7
date: Fri, 16 Jan 2009 17:46:18 -0800
from: "Gary Kuznitz" <docfxit@xxxxxxxxxxxx>
subject: RE: Create dds from fdf

Thanks for the reply...

On 16 Jan 2009 at 17:41, DeLong, (DeLong, Eric <midrange-l@xxxxxxxxxxxx>)
commented about RE: Create dds from fdf:

Column heading cannot contain a space either... "Customer
Number" should
be "Customer_Number" to be correctly processed.

I don't have any spaces in the heading cells. It gives you an
error if you
do
and it won't continue.

Thanks,

Gary

Eric DeLong

-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx
[mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Dan Kimmel
Sent: Friday, January 16, 2009 4:57 PM
To: Midrange Systems Technical Discussion
Subject: RE: Create dds from fdf

Perchance does your column header row (row 1) (actually now in your fdf)
contain a column heading with a single quote(') and a forward slash (/) in
it?

Another possibility: Try kdichanges.memlb1 instead of kdichanges/memlb1
for the file name. You may have roamed into SQL naming rather than SYS
naming.

-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx
[mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Gary Kuznitz
Sent: Friday, January 16, 2009 4:02 PM
To: Midrange Systems Technical Discussion
Subject: RE: Create dds from fdf

Thank you for the reply...

On 16 Jan 2009 at 12:34, Alan (Alan Shore <midrange-l@xxxxxxxxxxxx>)
commented about RE: Create dds from fdf:
Hi Gary
can you please elaborate?
What are the steps you are taking?

1. I open up Excel and load the csv file.
2. This time I added a row (Line 2) with "test" (no quotes) into the
spreadsheet. The transfer saw this row as character and created
all fields
as character (not numeric) 3. I pressed the end button and the
home button
(so my cursor is positioned at the end of the spreadsheet.
4. I clicked on the icon that runs the macro to transfer to AS/400
request.
5. I enter the starting location of A1 (The ending location is there
already DF942.
6. The transfer request is create new. OK 7. Welcome. Ok 8. I select
Create new file and member based on spreadsheet. Next 9. I enter the fdf
file name of memlb1. Next 10. I click on start scan. Next 11. I see all
fields are character. Next 12. I enter the domain name of the AS/400.
MyDomain.com Next 13. On the Customize data transfer screen I
don't change
anything. Next 14. I enter the library and file.
kdichanges/memlb1 These
are not available if I browse. Next 15. For file text I don't
enter anything. Next 16. On the confirm create options screen I click on
Next.
17. It connects to the AS/400 and this is the error I am getting:
CWBDB0036 - Server returned SQL error

SQL0104 - Token / was not valid. Valid tokens: CHAR LONG BINARY DOUBLE
GRAPHIC CHARACTER <IDENTIFIER>.

Cause . . . . . : A syntax error was detected at token /. Token / is
not a valid token. A partial list of valid tokens is CHAR LONG BINARY
DOUBLE GRAPHIC CHARACTER <IDENTIFIER>. This list assumes that
the statement
is correct up to the token. The error may be earlier in the
statement, but
the syntax of the statement appears to be valid up to this point. Recovery
. . . : Do one or more of the following and try the request again: --
Verify the SQL statement in the area of the token /. Correct the

statement. The error could be a missing comma or quotation
mark, it could
be a misspelled word, or it could be related to the order of
clauses. -- If
the error token is <END-OF-STATEMENT>, correct the SQL statement
because it
does not end with a valid clause.

Thank you for looking at this,

Gary



Alan Shore
Programmer/Analyst, Distribution
E:AShore@xxxxxxxxxxx
P:(631) 200-5019
C:(631) 880-8640
"If you're going through Hell, keep going" - Winston Churchill

midrange-l-bounces@xxxxxxxxxxxx wrote on 01/16/2009 12:04:09 PM:

I am using the macros. When I do I get the SQL error. How can I
fix the

error?

Thanks,

Gary Kuznitz

On 16 Jan 2009 at 9:54, David (David FOXWELL <midrange-l@midrange.
com>) commented about RE: Create dds from fdf:

I use the macros to send and receive directly from/to EXCEL in the
toolbar named iseries access.

-----Message d'origine-----
De : midrange-l-bounces@xxxxxxxxxxxx [mailto:midrange-l-
bounces@xxxxxxxxxxxx] De la part de Alan Shore
Envoy? : jeudi 15 janvier 2009 21:57 ? : Midrange Systems
Technical Discussion Objet : Re: Create dds from fdf

Hi Gary
save the file from Excel as a CSV file if you have Client access,
here an overview of what can be tried,
click on Actions, then Send File to Host another window should
appear (Data Transfer To iSeries) click Tools click Create iSeries
Database file - this will display a Wizard. Follow these
instructions and an fdf file will be created.
Eventually, the wizard will finish The Data Transfer To iSeries
window should then have both the PC
file name AND the iseries file name filled in Press
Transfer data to
iseries and the data will be loaded to your system.



Alan Shore
Programmer/Analyst, Distribution
E:AShore@xxxxxxxxxxx
P:(631) 200-5019
C:(631) 880-8640
"If you're going through Hell, keep going" - Winston Churchill






midrange-l-bounces@xxxxxxxxxxxx wrote on 01/15/2009 03:37:53 PM:

I have a csv file with a lot of fields in it that I would like
to got
onto an
i5. I can bring up the file in Excel and create an FDF with the
field
names.

Does anyone know of a program on the i5 that will
convert an FDF
file to
DDS.
I don't have the file created on the i5. Client Access won't
createthe
file
on the i5 from Excel

Thank you,

Gary Kuznitz


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

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

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



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





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

--
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 8, Issue 92
*****************************************


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



As an Amazon Associate we earn from qualifying purchases.

This thread ...
Replies:
Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2025 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.