If this is your first visit, be sure to
check out the FAQ by clicking the
link above. You may have to register
before you can post: click the register link above to proceed. To start viewing messages,
select the forum that you want to visit from the selection below.
Could you please share step by step process to download excel file from any physical or logical file using RDi (as you mentioned - "for Run SQL scripts and then use that to produce a CSV" )if possible with screen shots please?
Also what is this DBeaver does it come somewhere with RDi itself or needs to be installed or downloaded separately or is it under some submenu option within RDi?
I got it, but can a file in excel be downloaded with full field text currently I tried to download it using with different file details options as offered by RDi like None, Column names, column headings one by one each but none of these options served my purpose and file is not getting downloaded with full field's text description, any other way to achieve this please?
It can be a physical or logical file which is on IBM i and I want to download it in Excel format using RDi.
I mean to say file does get downloaded but full column description text is not coming under column headings. which we usually can see when we do runqry * n filename and then we do F4 and then we do F11 then we can full text description of all the fields that details description i want to be downloaded in my excel along with file's data so column heading should contain maximum full description of all the fields along with file's data.
Hope this helps for clarification.
The only standard tooI know of is CPYTOIMPF which has added this ability in recent years. If you want to implement it from within RDi - still don't know why you want to but ... - then you could define a user action that invokes the command. See https://www.ibm.com/support/pages/ad...ut-streamfiles for the detaisl of the command you need.
that link points toward writing a whole CL program any single CPYTOIMPF command or any other easier way to download that file with full column headings please? full column headings are required to understand data with more clarity.
Why do you care? There is no single command that will do what you want. As long as the net result is a single simple command that can be issued why does it matter? Under the covers IBm commands issue all sorts of program and procedure calls.
You can write programs that use the HSSP APIs directly, you can use the Easy400.net Excel commands which perhaps can do what you want. Check the Office integration stuff here: https://www.easy400.net/easy400p/mai...in=2&xlng=en#3
RDi has a Database Development view. Its tools allow you to both load information from Excel spreadsheets into physical IBM i files and do the opposite.
In mine I only get offered CSVs - not Excel. And I see no way to do what the OP requested re column headings. Am I missing something or have you got some kind of plug-in deployed?
Comment