Anyone familiar with 4D front end to DB2 database

365 pts.
Tags:
IBM DB2
IBM iSeries
Has anyone had experience with using 4D (4th Dimension) as a front end of IBM DB2 on iSeries? I've tried FTPing a database, it was downloaded to a PC into Excel, Excel had no problem retaining formatting...however I can't get DB2 to maintain the formatting and I used DDS to to generate the physical file (PF)?

Software/Hardware used:
IBM iSeries on V5R2, Excel on Sony notebook running Vista

Answer Wiki

Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Discuss This Question: 6  Replies

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • TomLiotta
    What do you mean by "FTPing a database"? Generally, databases are not FTPed. Usually streamfiles are FTPed, though in some circumstances a table or even a view can be FTPed.   Also, Excel is mostly guaranteed not to maintain the formatting of a database table. It might handle the format of an import/export streamfile, e.g., a .CSV file, but Excel generally has no idea how to handle database table formats. Excel is not a DBMS.   Where did you FTP from and where to? How did DB2 get involved? What DB2 was was unable to "maintain the formatting"? And how does DDS fit into any of this?   Please try to clarify what you are actually trying to accomplish. What is the actual problem that you have?   Tom
    125,585 pointsBadges:
    report
  • Gmil494
    I'm trying to download to the IBM a relational database in 4D (on Apple, but it also 4D also runs on Windoze PCs), actually 19 relational tables, into (I believe a maximum of 32 table/files open at one time is the limit V5R2) DB2, link the files (relationally I have the entity-relationship diagram for the 19 files/relationships, import the database/files) and then use LF's multiple format to access the data.  The database (in the various 19 related files) currently has over 1 million records.  What I was trying to do is create DDS for each of the 19 files then import/download each file, then link them, create the LF's.I've seen menu options for Stream Files, but so far, I cannot find any IBM documentation (Boulder site) on stream files.A person told me that 4D has supposedly been used as an RDBMS front end to DB2, and was wondering if there is any middleware/applications/utilities outside of using SQL/400...the box does not have SQL licensed.  Creating a PF without DDS (no SQL) creates only one large field..which will end up where I am at now...with the data there...but all crammed together...The intent is to have the database accessible online...if this answers intent and possibly some other questions you may have.
    365 pointsBadges:
    report
  • TomLiotta
    …the box does not have SQL licensed. Before you get much deeper into this, you need to know that the SQL license only covers green-screen user interfaces and language pre-compilers. SQL itself has been part of every OS release for the past couple decades.   So, for example, you can use the iSeries Navigator PC function to generate, create or submit SQL statements to the server. Other remote DB2 clients also exist that provide access to the server's DB2 SQL. Because iSeries Navigator is free (and relatively widely known to the AS/400 community), it's probably your best starting point.   Can you say anything more about the server? At V5R2, it's pretty old (a few years out of support). That sometimes indicates that secondary products such as iSeries Access aren't installed and even that install media is not available. Often worse, the products might be available for install, but needed fixes are not available.   If more is known about the server and its status, good help might be available.   Tom
    125,585 pointsBadges:
    report
  • Gmil494
    I wasn't aware that iSeries Navigator was free...I guess I'll have to investigate where to get iSeries Navigator, especially if SQL can be used from it, if not licensed for 5250/green-screen use.I've looked at the PTF's some are superceeded, some are applied (40 pages worth!) temporary and some are applied permanent.  Any PTF's would probably nearly impossible to acquire at this point in time.  I appreciate the information!
    365 pointsBadges:
    report
  • Gmil494
    I've searched and cannot find where iSeries Navigator is free and available for download, on IBM or other sites.  Other DB2 remote clients?  Any suggestions?
    365 pointsBadges:
    report
  • TomLiotta
    I guess I’ll have to investigate where to get iSeries Navigator...   Usually it's installed/downloaded from the server through a mapped drive. It might be a challenge if you have a newer Windows PC (or other OS). See Installing iSeries Access for Windows for standard V5R2 documentation.   The iNav function is one of the iSeries Access components. You can install just iNav or as many iAccess components as you wish. A couple components require licensing, but the server might be licensed for them. Regardless, iNav is free.   The biggest issue will be any fix packs for iNav. If those weren't downloaded and stored on the server (or in some accessible network location), you might not get a useful working copy. The PTFs for the server side might be in good shape. Hard to say. The PC side though could be tricky.   Tom
    125,585 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following