• Field editing for DB2 WebQuery

    How can I provide field editing for DB2 WebQuery? For example: phone number(length 10, decimals 0) as (123)456-7890 and Customer Id# (length 6, decimals 0) as 1234-56 . DB2 WebQuery doesn't seem to pay attention to the edit words/edit codes of the PF DDS, so I am trying to do my own "editing". I...

    AS400 - Ask the Expert485 pointsBadges:
  • Why do IT projects fail?-3

    Hi, I'm a Computer Engineering at CSU Chico. I'm conducting a research paper on "Why IT Projects Fail". If someone could give me an example of a failed projects, "failed" meaning that it didn't get finished on time, or the final project did not meet the requierments. Also if you could give a quick...

    Dbrazeau10240 pointsBadges:
  • SAP 4.6c migration from MS SQL 2000 to IBM iOS DB2 database

    Hi I need to investigate the work load required to migrate SAP4.6C HR from a MS SQL2000 database to a Integrated DB2 IBM i OS Database? Is there tools available for this ? any information will be beneficial Thanx from a system i techie that know nothing about SAP!lol

    IEnter5 pointsBadges:
  • How can i connect DB and input values in stored procedures using VBA

    hi all, i am using a automation tool, which is with VBA scripting. I want to execute the stored procedure by giving the values. guys help me....

    Jprpvk5 pointsBadges:
  • Export in db2 iseries

    i want to export query output to a csv file on iseries ..can anyone tell me how to do that

    Hn25 pointsBadges:
  • export to csv file from java app

    In windows our java application calls one .bat file which runs db2 export command to export data to csv file,how can i do the same on iseries...i dont have any knowledge of iseries and we need to deploy our application on iseries ...can anyone tell me how to do the same thing on iseries

    Hn25 pointsBadges:
  • RAID configuration for Oracle database

    Presently we have a 9iOracle database sized at approximately 50MEG on an HP-UX 11.11 server on a SAN. Our software app vendor is telling us that we should have the database on RAID 10 for better performance. They have done benchmarking with DB sized at what ours will be in the future. (Multi...

    Roadkill0 pointsBadges:
  • DB2: Optimizer not using any indexes

    I have DB2 version 8.2 installed in AIX one thing I am seeing is strange that optimizer not using any indexes. In any simple join index are not being used. Is there any parameter which needs to be set up?

    AS400 - Ask the Expert485 pointsBadges:
  • Mainframe Career – is it possible for me?

    hello, I have been working for a MNC in India for the past 2 years.My nature of Job includes creating SAS programs and using JCL to run this SAS and get reports or other stuff from the DB2 databases or files.I also write simple SQL queries for DB2.I am right now in a stage where i need to decide...

    Richard19835 pointsBadges:
  • How to restrict QMF to execute predefined queries only?

    Hi, is there a way to restrict the usage of QMF/390 to predefined queries/procedures only? Some users should not be able to edit or create SQL statements on their own. Thank you very much. Regards Michael

    Meichhar5 pointsBadges:
  • left outer join in trigger DB2 Z/OS

    I'm having problems writing a trigger that contains a left outer join. Here is the trigger: CREATE TRIGGER H000.H0TRCAD2 AFTER DELETE ON H000.H0COO_TRANS_CALLC REFERENCING OLD AS OLD_ROW FOR EACH ROW MODE DB2SQL BEGIN ATOMIC SELECT OLD_ROW.CLNT_ID , OLD_ROW.ACCT_NBR , OLD_ROW.PST_DT ,...

    X000055 pointsBadges:
  • PL/I DB2Stored procedure Execution

    How to execute the PL/I DB2 Stored procedure in Mainframe environment?

    Swapna110 pointsBadges:
  • How can i connect Notes to AS400 (DB2)

    Hello, i have a problem trying to connect our DB2 Database. I use DECS administrator to set up a connection-document to our AS400. To set up a connection-document i've used the instruction from IBM (http://www.ibm.com/developerworks/db2/library/techarticle/dm-0408gupta/index.html) When clicking on...

    JanSchils45 pointsBadges:
  • SQL DB2 COBOL date reformatting

    Hi and thanks in advance, I want to use DB2 SQL in COBOL to reformat a date from CCYY-MM-DD to MM-DD-YY. What is the simplest and most efficient way to do this? Christy

    Ctrevino10 pointsBadges:
  • DB2 and talend

    I do get the error below when i try to load table in DB2 iseries through ETL tool Talend [IBM][iSeries Access ODBC Driver]Column 6: CWB0111 - A buffer passed to a system call is too small to hold return data can anyone guide me what could be the error

    Jacky160 pointsBadges:
  • Need help with FILEAID in BATCH

    I'm new to FILEAID, so I'd be grateful for some sage guidance on FILEAID command syntax's and statement for use in a JCL. My problem is that Ihave a datafile which appears be a VB file type with a leading 2 character string ahead of my data. I'm trying (desperately) to create a work-around in order...

    Jonty Walker105 pointsBadges:
  • XML-INTO

    I'm trying to use XML-INTO with %XML to convert an XML document into a DB2 database file. The XML file has four levels of data with elements from each level that need to be used for the database record. Naturally, the relationships between the level are important, too. The levels are Header...

    GLinds0125 pointsBadges:
  • good PL/SQL user guide

    I am interested in a good reference guild for PL/SQL which explain all utilitity commands and configuration patterns and files. Your help is much appreciated.

    Hfeshari0 pointsBadges:
  • V8 CMP EDM Pool

    Strobe shows very high CPU in Module DSNGEDM Sections DSNGECMP & DSNGEPUF (which free expanded EDM Pool Storage) for dynamic SQL in a CICS Region. Is this an EDM Pool sizing issue?

    Winger19515 pointsBadges:
  • Dynamic sql with delete and commit

    Hi, I need to delete rows from different db2 tables in COBOL with commit in between after some 100 or 200 rows. Is there any away I can restrict my delete statement for some particular rows as in Select for fetch first 100 rows only. The values of table names will be known only during the execution...

    Sramki0 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