× 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

Thanks for looking at this.

On 16 Jan 2009 at 16:56, Dan (Dan Kimmel <midrange-l@xxxxxxxxxxxx>) commented about 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?
No. The header row only has the name of each field. The cell in every column
in the second row now hat "Text" to force it to be character mode.
You will see the letters TEXT in every column.

Another possibility: Try kdichanges.memlb1 instead of kdichanges/memlb1 for the file name. You may have roamed into SQL naming rather than SYS naming.
There is an example on that window to enter it as Libary/file(member)
I tried it with kdichanges.memlb1 and it gives me an error saying "The AS/400
file specified is not valid"
I have also tried kdichanges/memlb1(memlb1)
It produces the same error.

Thank you,

Gary


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




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.