• DB2 WebQuery for System i problem

    Hi! Our server has already installed with DB2 web query. I have checked the basic things in licensed programs like QWEBQRC77(*lib) , MRADMIN(*usrprf)...everything is there. But when I try to start web query, the command is not available and also in license programs the web query shown like...

    Sureyz2,375 pointsBadges:
  • AS/400-DDL: Create table command

    I have created table using CREATE TABLE command. I want to see the source of table. Is there a possibility to view the table's source in AS/400

    rajeshece1,215 pointsBadges:
  • AS/400-DDL: Create sequence command

    I have created sequence using CREATE SEQUENCE command. Then I have noticed that one data area is created in the same name. What is the actual purpose of sequence?

    rajeshece1,215 pointsBadges:
  • Current date in DB2/400

    IN DB2/400, is there a field level keyword for showing the current date?

    JIJUKALLIATH5 pointsBadges:
  • AS/400 access control for sensitive commands

    Is there a way to verify list of users granted access to sensitive commands ADDAUTLE| CHGAUTLE| CHGDTA.....? As these commands are executed at the green screen of the systems. How to identify who has access to the green screen.

    Anukku30 pointsBadges:
  • AS/400 access control for commands

    Some of the system commands are considered to be powerful like, {*USRPRF,*AUTHLR, CHGSYSLIBL, CHGSYSVAL, etc}. 1. Limiting capability does not restrict a user from executing a command. If so how can we restrict the user access to these commands? 2. Is there way to list all users with the access to...

    Anukku30 pointsBadges:
  • Forms

    I have a form (frmInvoices) used to enter new invoice data. It's control source is tblInvoices. But on my form, I have 3 fields to pull data from: (tblcustomer.customerid) and (tblnewinvoices.id; customerid; and datecreated) I can't figure out how to populate datecreated and id from tblnewinvoices...

    Noreene5 pointsBadges:
  • My operating system was upgraded from V5R3 to V5R4

    my operating system was just upgraded from V5R3 to V5R4. All my cobol programs are compiled with *none commitment control and a target release of V5R3M0. However after upgrading the operating system while executing the programs -913 errors are being encountered. The same programs are getting...

    Priyaranjanltcp0 pointsBadges:
  • What is IPSec? How to config frame relay?

    How to config the frame relay? with brief example (using all configuration)

    Kaja20048055 pointsBadges:
  • MySQL stored procedure debugger tool

    Hi, I am looking for a MySQL stored procedure debugger tool for Ubuntu (Unix). Can someone help?

    Perfsid5 pointsBadges:
  • 24 hr clock in Microsoft Access

    Microsoft Access allows you to open your table in datasheet view, select FIELDS from TABLE TOOLS and select from the drop down MORE FIELDS and then select TIME 24 so you can use military time. Problem is when you attempt to type in military time, it shows a calendar on the side and only allows you...

    MANDONA135 pointsBadges:
  • Relationship between database and knowledgebase

    What is the relationship between database and knowledgebase?

    Mkaaa15 pointsBadges:
  • Collation

    What is simple definition and example of collation?

    Raviknowledge5 pointsBadges:
  • Access 2003 parameter query bollixed

    The query searches a table looking for three fields, one of which is the Year. The year parameter request works just fine [Year as yyyy]. The query then goes on and asks for a second parameter for a field that was not included as a requested field. Any hints given are appreciated - thank you wem3rd

    wem3rd65 pointsBadges:
  • Create Button to Open Specific Form

    I have a continuous subform. I have added a command button beside each record on the subform to open another form, which is specific to that record. Every time I use the control wizard to make the button, the record I want is not opened. My relationship is Continuous ID to Button Number. I am not...

    a2rose2l5 pointsBadges:
  • Application retirement and database archiving

    Hi! I have a constantly developing application and i want to archive its DB. The DB tables structures constantly change. My idea is to develop non changing core structures (tables) of production tables. It will be something like physical DataMart. For example if I have client information in...

    shorri5 pointsBadges:
  • StartDates

    How would you write the "Where" clause (sql) for abstracting just the "Year" out of a startdate like 03/12/2013 which would result in an answer of "2013"?

    nrgbmill5820 pointsBadges:
  • Access List

    Hello there, I would like to set up a firewall and i need some help in order to use the correct filters (access lists). I want to achieve the following: 1. The external users can access the server (website and ftp) in the DMZ 2. The external user can download files from the server via ftp 3. The...

    Olych5 pointsBadges:
  • What is the best method to connect Oracle and DB2 DB with HIGH reliability and speed?

    Hello, My company currently has 2 ERP systems: JDE (in Oracle) and another which has 3 of our divisions. The decision has been made to move the remaining 3 divisions to JDE. The other divisions currently push pricing to the 2nd ERP system from home grown Contract Systems on the System i nightly...

    MaryKyrrynMathias70 pointsBadges:
  • IF and then statement in query

    I'm having issues with an if statement in a query. Basically I need to know how to get the following: If field 1 is > 0% then field 2 = 25. I don't know VBA

    tphester5 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