• When I ran a SQL thru JCL and using DSNTIAUL/DSNTIB81 using PARMS(SQL), what kind of locks it puts on table in SELECT statement?

    When I ran a SQL thru JCL and using DSNTIAUL/DSNTIB81 using PARMS(SQL), what kind of locks it puts on table in SELECT statement?

    Rofnh20 pointsBadges:
  • how to block update command when using STRSQL ( db2/400)?

    Hi People , I got several analysts that they must only use Select command through STRSQL prompt, I found I can block update command changing the object authority but I have loads and load of tables to change, is there any easier way to do that?

    Altino20 pointsBadges:
  • SQL embedded in RPGLE

    RPGLE program with five modules updating different set of files. Main module calls others each time a customer is being processed to change some specific detail in many files. There are many customers, so the modules are called many times (LR is set on only at the end of the whole process). Each...

    Mawc10 pointsBadges:
  • understanding and detecting sql performance situation with abnormal 400 shutdown

    Need help in understanding and detecting situation with logical files built for sql rpgle performance and abnormal shutdown. Our system went down due to ups failure. All of a sudden the rpgle sql program is a resource hog because it is not selecting the lf that was built specifically for...

    Modiyooch540 pointsBadges:
  • Windows ODBC driver for IBM DB2 database

    I'm looking for a windows ODBC driver to access a DB2 database on the AS400. Does anyone have a link or suggested vendors?

    mshen27,385 pointsBadges:
  • AS/400 data mapping with CPYFRMIMPF

    We have an application in which we need to expand the size of several fields within the record, ie the Amount field need to be larger. In the past I would create DDS for the new expanded file, create the file, then write an RPG or Cobol program to copy the data from the old file to the new expanded...

    GarySouders10 pointsBadges:
  • copy file to PC

    I need to know how to copy a native iSeries DB2 file to the IFS in PC file format

    StillKickin5 pointsBadges:
  • How to check DB2 version in AS/400 green screen command line?

    How to check db2 version in as400 green screen command line?

    Hiraju115 pointsBadges:
  • CPYTOIMPF –FLDDLM(*TAB) QUESTION

    Our OS is V5R4. I am using cpytoimpf to import .txt file (tab delimited) to DB2 physical file. If I remove the FLDDLM(*TAB), I get all the records but the fields have overlapped data. If I use the (*TAB) I get one record and errors on the remaining copy.(error code 7) Here is the command I am...

    VRSTEEL5 pointsBadges:
  • Mainframe batch DB2 table I-O monitoring

    Dear Sir or Madam: I can examine the excp counts for flat, VSAM, IMS files in the JCL batch JES JOB Log statistics, both while executing & when job has completed. How do you monitor that I/O for DB2 tables? Thank you, Michael Piccolo

    Pic40 pointsBadges:
  • How to Determine Database Access on AS/400

    I have a client running JDEdwards on an AS/400. How can I determine which of the users have direct access to modify the DB2 database (access to DB without going through the JDE application)? Is there a particular security profile they must have? Thanks in advance.

    DaCurryman5 pointsBadges:
  • error in connection between oracle8i&developer2000

    I'm installing Oracle8i on Windows 2000 professional on NTFS partition and on the same machine I'm installing Developer 2000 or form6 in a different partition. When I try to connect Developer to Oracle, I get the error "TNS could not resolve." Please provide a solution. Can I use Oracle8i...

    POWERINIT0 pointsBadges:
  • DB2 SQL Confusion

    I am failing to understand why the following won't work SELECT m.index, SUM(d1.amt), SUM(d2.amt) FROM master m, detail d1, detail d2 WHERE m.index = d1.index AND m.index = d2.index AND d2.qalif = 1 GROUP BY m.index I wrote another sql that does work, I just don't understand why I get higher values...

    ThorButtox5 pointsBadges:
  • Slow JDBC DB2 Connection

    Hello, Having an issue with a new server we are setting up. The server is Linux RHE 4, running DB2 8.1 and Domino 7.03. Our DB2 databases reside an a separate dedicated DB2 server and are cataloged on our new server. Connections to these databases are working fine using SQL tools and from the...

    Biohazard425 pointsBadges:
  • AS400

    In DDS, Unique is file level keyword. Is there any specific key word for field level?

    rajeshece1,215 pointsBadges:
  • How to configure the database instance to respond slowly for any request?

    With default configuration settings at DB instance, the db server is responding quick. For my tests, i want the db server response to be slow. What configuration changes or anything else can be done so that the db instance will respond slowly (atleast take 1 minute time to execute). The request can...

    Saimadhu455 pointsBadges:
  • Native database implementation on AS/400

    Hi, I am searching for a native database implementation for AS400. Either an open source or that can be bought and used or ( a database impl that can be achieved by doing some programming). Can i get some help regarding this. Thanks all, teja.

    Engineerteja5 pointsBadges:
  • What is the use of primary files in DB2/400?

    whats the use of primary file any real example please? in what scenario should we prefer to fully procedural file?

    6r1,485 pointsBadges:
  • How to test whether the Database tables designed to avoid deadlock occurence?

    I heard from our dev team that our db tables are designed such that there is no chance of deadlock. How to test whether the Database tables design avoids deadlock? By reviewing the db scripts (table creation) can we find whether the db table design is deadlock proof or not? What else can we do?...

    Saimadhu455 pointsBadges:
  • Referential integrity and AS/400

    Can anyone please explain what refrential integrity means and how does it relate to AS/400? Regards, Shaddy

    Shaddy20 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