• Create a view in DB2/400

    I need an example to create a view in DB2/400. I Need to create a view where the table name is greather than 8 characters and collumns names greather than 6 characters. please somebody can help me??

    ITKE342,600 pointsBadges:
  • db2/400

    Hi, Please give the answer to this question? I have Phisical file with 100 records,there is no any duplicate records in this pf.Based on this pf one Logical file i have used.But this lf is viewing only 80 records only of that pf?What is the reason for this?Please give me answer?

    Repaire45 pointsBadges:
  • DB2 / ODBC file availability

    We have a new web app that we want to be able to run 24/7. My question from our web staff isĀ  "when the data is available? ". There are 2 situations I can think of that will pose an issue. 1. when we are running file back ups, it most likely will not be available due to object locks. We could do a...

    ToddN20008,500 pointsBadges:
  • MS Access – AS400 file transfer

    I am trying to move data from a .dbf file to the AS400. I have tried several differnet methods from access and none of them worked. I tried setting up an ODBC table pointing to the as400 and doing an update query and also an export. I could not get either of these to work. One of them kept bringing...

    Ddune35660 pointsBadges:
  • execution of multiple querries with SPUFI and QMF tools

    hello, how can i execute multiple queeries with the help of tools- SPUFI and QMF respectively. thank you

    Programming440 pointsBadges:
  • Oracle In Linux

    How can I able to get and work with Oracle in Linux platform. I am using RedHat Linux 9.0.

    Samachar0 pointsBadges:
  • Data Access to DB2 in RPG program

    I want to know how to connect using connection string to DB2 instead of using pf file in RPG program.

    H2a5 pointsBadges:
  • DB2 data over web browser

    Our solutions resides in System i and its all are internal developed systems. Our applications are Logistics business driven and now we have the need to publish these informations over web for view by customers. HOW do i do that.. and what should i consider..

    bsathia20 pointsBadges:
  • DB2 Table Size in V6R1

    Upper limitation of Table is 1.7TB in the V5R4 version. How about the limitation in V6R1?

    David Chen20 pointsBadges:
  • COBOL date reformatting

    I am getting a date from DB2 and I need to reformat it in COBOL. It will eventually be used in DOC1 so I need it to look like a date (i.e. with slashes or dashes). DOC1 was not recognizing the date I am passing in because right now it is just a numerical string, so I could not cast it as a date in...

    Skmcm40 pointsBadges:
  • How to learn DB2?

    How to learn DB2? Is there any possible way to install in a PC and practice? if then guide me please...............

    Sriramsankarc10 pointsBadges:
  • DB2 image copy that is no longer in SYSCOPY on zOS operating system

    We have a tablespace that needs to be restored from an image copy which we have the problem is the image copy is not recorded in SYSCOPY. We also tried doing a UNLOAD FROMCOPY thinking if we got the data out of the image copy we would be able to load it back into the table. That also failed with...

    EPPERSON5 pointsBadges:
  • RRN Max

    Is there a way to allow more than 1 billion records in a DB2 File? We have reorged to file to get rid of deleted records, but are still out of room. The system will not allow one more record to be added because we have reached 999,999,999 records.

    Nay ray5 pointsBadges:
  • AS/400 and Oracle Access Manager

    I have a strange behavior in an SQLRPGLE program accessing iSeries DB2 and Oracle via Oracle Access Manager. The program is very simple and reads values from two Oracle Tables in this way : a. SELECT .... into ..... FROM Table1 WHERE ..... return OK : 1 row as expected with my two fields filled. b....

    Technet30 pointsBadges:
  • DB2 to SQL Server migration

    We have a client that is migrating from the AS/400 DB2 to .NET and SQL Server and they want us to find them a resource to help locate and then migrate the data stored on the DB2 data base to SQL Server and I was wondering if that is more for a DB2 DBA or for an AS/400 Systems Analyst? Also, the...

    SolpartDean5 pointsBadges:
  • DB2 WebQuery: Metadata Error FOC1567

    I'm new to DB2 Web Query. Just starting with the product. In metadata, I'm trying to pull in a DB2 SQL derived Table. I keep getting an error FOC1567. *LOCAL, <create synonym>, Table <only>, library / filename Error FOC1567 Create Synonym Data Source 'StockKeepingUnit' is not unique The...

    Dlanor20 pointsBadges:
  • How to calculate logical file size

    Hi, I need to be able to estimate the size of a logical file (inc access path). I've tried creating this file and almost filled the machine up. This is logical has quite a lot of key fields. Does anyone know a simple way of estimating the size (IBM has a formula in the manuals, but I can't make out...

    Gilly40023,730 pointsBadges:
  • OLE DB using Library List

    Hi, Do any one use OLE DB to connect to iSeries? Is OLE DB capable of using Library List provided by Job Description? Because when I used it, I have to specify the library name / schema and object name. Please advice... Thank you

    TG50 pointsBadges:
  • How to use PL/I command LIKE with DB2

    I wont to use PL/I comman like for using same structure twice. Compiler returns error : IBM7043I S 4.1 SQL0314N The host variable "xxxxxxxx" is incorrectly declared. SQLSTATE=00000 IBM7043I S 9.1 SQL0117N The number of values assigned is not the same as the number of specified or implied columns....

    Sccsofti5 pointsBadges:
  • DB2 Web Query – Active Report Show Unreadbale Data

    I have a report contains some information about customer name. When I save the output type as HTML ,the result is pretty good. The problem is, it is not good when save as Active Report AHTML. In each columns contains customer name in Thai will display as garbage or alian. How do we control this ?...

    Liverpoolfc20 pointsBadges:

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