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




As an Amazon Associate we earn from qualifying purchases.

This thread ...
Follow-Ups:
Replies:
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.