Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Wanet Telecoms Ltd on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. Shihab71

    How can I get the DB structure of DB2 database on AS/400

    Just saw your post. Maybe you have already achieved what you wanted, but anyway another tip never hurts. I have done the same by using Sybase PowerDesigner. You will have to purchase it or get an evaluation copy from your local dealer. Just create an ODBC to the AS/400 library, open...
  2. Shihab71

    Linked Server to SQL Server

    OH!!!! forgot to add the pre-requisite You will have to install Microsoft Host Integration software. This has the Microsoft OLE DB Providor For DB2 drivers. Shihab Mohd
  3. Shihab71

    Linked Server to SQL Server

    Hi arst06d, Had a lot of trouble in doing the same, but finally got thru. Here's what I did. In enterprise manager, security linked servers new linked server The dialog box will open up. In the column Product Name, type in : Microsoft OLE DB Providor For DB2 Type in a DSN Name (just to be on...
  4. Shihab71

    Calling RPG Prgram from VB

    Thanks for ur assistance. TomKane, I cannot run from the DOS mode so no luck there. JBradley, I tried out your option and it works beautifully. I got the ActiveX control from Mabry. The only problem is that our FTP ports are routinely blocked due to security reasons. Don't ask why but that's...
  5. Shihab71

    Calling RPG Prgram from VB

    Hi all. I need some help on how to call a RPG program through my VB application, passing a single string parameter. At this point I do not need a return value. I am using VB 6.0, connecting to AS/400 via Client Access Express. Thanks in advance.
  6. Shihab71

    Create VB Program to call a RPG program

    I need to know how I can call a RPG program through my Visual Basic Code. I also need to pass a parameter to the RPG program. My set up here is VB 6.0, using Client Access Express to connect to the AS/400.
  7. Shihab71

    How to load 'tab' delimited flat file?

    To load a tab delimeted file to DB2 is pretty easy. First upload the text file to the AS/400. The use the command CPYFRMIMPF (copy from import file). The parameters are self explanatory. Please note that the character fields will have to have '' before and after.

Part and Inventory Search

Back
Top