Re: Making the most, or over-thinking it - SQL for uploads

Duane, I am having trouble understanding your situation. You said:

importing data from PC to DB2 is done constantly

OK, that sounds completely normal and I'm following you so far.

using SQL is my FIRST thought over most of the tools that we have access to, simply because of its convenience. At least perceived convenience.

Things are already going off the rails here. Then you continue:

As to the method that I used to get the data this time, I used Access Client Solutions Data Transfer. But doing so forced me to load the entire record to a DB2 data file from which I used interactive SQL from an IBM i ACS emulation session to INSERT my selected fields.

What kind of text files are we talking about? And are these text files
the "purest" source of this data, or are the text files just an
intermediate format used for data transfer? For example, is the REAL
data in another database, or an Excel file, or something else; and you
just copied that into a text file because you figured that it's easier
to get data from a text file into the i?

Until I get more details, the best my imagination can come up with is
very much in-line with what Vern is thinking. Just get your text file
into the IFS and take it from there.

I am not sure what is going on with your conversation with Buck. To
me, it seems like Buck misunderstood your original post, and thus
brought up lots of correct but irrelevant stuff, yet you seem to be
good with his response. So I am really clueless there.

When you say things like:

I'm not familiar with setting up the PC to interact.

and

I really just figured that I could access text files similar to accessing them as done on IBM i.

These things make me wonder what RDi has to do with anything.

Finally,

I also figured that it was my own lack of experience and knowledge of setting up the PC that caused the inability to just find the file and open it up.

Um, "just find the file and open it up"? Find the file *from where*
and open it up *with what*? It almost sounds like you want to be able
to "find" the file from the i and open it up with whatever it is you
use on the i to work with stream files (such as an RPG program or the
EDTF command or CPYFRMSTMF or CPYFRMIMPF). There *are* ways to set up
some disk space that is directly accessible from both the i and a PC
(so you can just copy the data to that space from the PC side and pick
it up from the i side).

I think we could all use some more information about your situation.

John Y.