• hi all

    last day i installed one new xp theam on my xp system. recently i noticed that "RUN" option deleted from my start menu. can anybody help me in this problem ? thanks in advance

    Squibc40 pointsBadges:
  • AUTHID in DB2

    I want to define AUTHID while create stored procedure in DB2/AS400. This can be done in oracle as CREATE OR REPLACE PROCEDURE PRC AUTHID DEFINER / CURRENT_USER can this also be done in iSeries AS/400 DB2?  

    Bhadresh25 pointsBadges:
  • Querying multiple member PF with SQL

    I would need to SQL on a multiple member PF and I need to query the 2nd or nth member in the PF.  Is this possible just with an SQL query without using OVRDBF etc.?

    Rajgoaj280 pointsBadges:
  • Isolation level in iseries DB2

    How to set isolation level in iseries DB2? please reply.

    ORS5 pointsBadges:
  • Calling a URL length more than 200 from CLP

    Hi Techies, I would like to call a URL by passing some input values and retrieve some values from the results. 1. The URL lenght is more than 200, with special characters like % " < / > 2.I need to retrieve values from the particular website. Can u please help me out soon, its been getting...

    as400dev480 pointsBadges:
  • SELECT AND OMIT in RPGILE

    hI,GUYS,Actually select and omit used in lagical file to control the records,values like. But without key field how can i use these select and omit condition in logical file? And one more doubt is what is the exact uses of %SCAN,%SUBST, %SUBDT,%EOF,%CHECK,%COMMIT,%FOUND.Plese explain these

    0 pointsBadges:
  • DB2 (Oracle funtionality in)

    Hi, all I have no familiarity with DB2, but plenty in Oracle and SQL Server and other RDMS. In Oracle, I can access a flat file on disk by defining it as an External File. Similar functionality in SQL Server. My question then: Does DB@ on the mainframe have the same type of feature? Thanks in...

    Rireland5 pointsBadges:
  • Mainframe – Someone moving my DB2 Object to READ ONLY

    How to know who is or which application moving my TS to READ ONLY in a z/OS environment?  

    Geetika12315 pointsBadges:
  • DECFLOAT – Internal Format

    Hello, How to translate an internal DECFLOAT value into a visual format? DB2 Administration Guide: "Convert and return a DECFLOAT representation of a number or string representation of a number", (Appendix A. Writing exit routines). There is an example there: Internal...

    Eligin20 pointsBadges:
  • Need help executing MULTIPLE SQL extracts from a JCL

    GREYBEARD52: Thanks again for the info, BUT I'm not sure if a CL command can be used with a JCL. Can it? ALSO, my JCL uses the SELECT command, so it appears that the RUNSQLSTM command won't help - it doesn't support SELECT. Are there ANY OTHER ALTERNATIVES or a way to tweek this command to 1. Run...

    Jonty Walker105 pointsBadges:
  • Why does the keyword END is not accepted at the end of a stored proc ?

    Hey guys,  I have thise error in SQL stored proc.  I'm on ISERIES and I use RUNSQLSTM to very my procedure. could you help ?  It's seem I can't put a END at the end! ---------------------     160            AND DUDGCT =...

    FRANKIA5 pointsBadges:
  • is there any process to store the data of dataqueue

    is there any process to store the data of dataqueue

    Siru15 pointsBadges:
  • can anybody tell me how to know max sal in db2/400 means in pf

    can anybody tell me how to know max sal in db2/400 means in pf

    Siru15 pointsBadges:
  • Domino server R7 and DB2

    Hi all, I would like to setup a Domino 7 server and DB2. Our environment has experience seperate server for Domino 7 and DB2 server. Does anyone know that is tht possible to install Domino 7 server and DB2 into one single powerful server? Kindly advise. Thank you.

    R7130 pointsBadges:
  • Query Regarding Crystal Reports

    Hi, I need to produce a flat file in fixed length format as output of Crystal Report. Wanted to know if crystal report supports exporting data into a Flat file fixed lenght format. If yes, would like to know how to go about it.

    Vabene0 pointsBadges:
  • Optimizing/Indexing to find last transaction

    I'm hoping someone can help me out with this. I'm trying to write a query that will return the last transaction for each item in our warehouse. To do this, I'm using 2 files, first our location detail which has a list of all the locations in our warehouse. This file only has about 60,000 records,...

    MODMOD0 pointsBadges:
  • Data Access Layer in RPG

    Has anyone implemented a Data Access Layer in RPG-ILE, similar to what is discussed in these articles: http://www.itjungle.com/fhg/fhg072104-story01.html and http://www.itjungle.com/fhg/fhg011205-story01.html If so, can you share some of the positives and negatives of the experience? In hindsight,...

    johnpquinn5 pointsBadges:
  • Stored Procedures on AS/400

    Greetings, I understand SQL stored procedures on the AS/400 generate C source code which is compiled to create a C ILE program object. I could use the same SQL statements in an RPGLE with embedded SQL program and use that to create a RPG stored procedure. Which of the two is more efficient? Thanks...

    Ashnirody100 pointsBadges:
  • DB2 Load Utility

    If I run the DB2 LOAD utility LOG NO REPLACE is all the data externalised to DASD immediatley ? I.e. if I ran DSN1COPY against the underlying VSAM dataset immediately (without stopping pageset) would all rows be copied ?

    Ian in Uk5 pointsBadges:
  • Performance Problem

    We are experiencing intermittant performance problems most likely related to the update of a file that saves emails sent to customers. The problem may be related to a 10,000 byte text field for the body of the email message and/or the size of this file (2 million records). The file has one index...

    Ashnirody100 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