• SQL statement Token error

    I keep getting a token error in my SQL statement.

    RateWatchProgrammer10 pointsBadges:
  • ORA-01445: cannot select ROWID from a join view without a key-preserved table

    Hello, For the first time in my IT-life I've encountered following error message when I try to run query using ROWID on a view: ORA-01445: cannot select ROWID from, or sample, a join view without a key-preserved table I found something about key-preserved tables, but I'm not sure that my...

    LukyFox25 pointsBadges:
  • Rookie using DSNTEP2 and IBM JCL – Need Help with JCL

    I'd appreciate some help here. My JCL background is HP3000 / MPEX and HP-UX, but my IBM mainframe JCL experience is over ten (10) years old. So I'm having problems creating a JCL - my brain can't remember command syntax's from that long ago. I need to create a JCL that will accept an input file of...

    Jonty Walker105 pointsBadges:
  • Create a sequence called Store_seq with the following values: increment by 10, start with 500

    Create a sequence called Store_seq with the following values: increment by 10, start with 500

    VB RD45 pointsBadges:
  • Regarding datetime function

    How we get output as (weekday date) eg: monday may5 1996?

    rbccollege285 pointsBadges:
  • Oracle SQL query

    How do I list the mid-western vendors (Illinois, Indiana, Iowa, Minnesota, Wisconsin)? Also display the vendor ID, name, contact name (first & last), city, and state. Use formatting and concatenation to reduce the space required for the contact and city (30 characters should be fine). Order the...

    kmoses5 pointsBadges:
  • SQL query for employees in my department

    We need to find 50% of employee from each department, who is getting max salary. And every department have different employee count. ex. finance may have 100 employees and sale may have 40 employee. How do I write a query for this?

    mukeshkumar1230 pointsBadges:
  • Oracle 11g KEEP buffer pool

    What is the SQL to determine what table objects are in the KEEP buffer pool?

    jmarsh5 pointsBadges:
  • Find missing numbers with SQL

    In a large logfile I have records containing the field INVNO (invoice-number). The lowest and highest values are easy to find, BUT it looks like some numbers in between are not there. Anyone got a trick with SQL, which can tell which numbers are missing within the numberrange (step 1) ?

    DanTheDane2,555 pointsBadges:
  • Retrieve SQL messages from Joblog

    Hi, I'm on 6.1 and I have RUNSQL in a CL program. The statement is 'UPDATE ...' and run's okay but I need to get the SQL MSG SQL7957 with the number of rows updated or the SQL0100 (row not found). I can get this with RCVMSG but only in debug mode. Can anyone help me? Rui

    RuiFerr15 pointsBadges:
  • How do we work with SQL?

    How do we work with SQL and what does it help in DBMS?

    veronicahmungai20 pointsBadges:
  • Test environment – stop iSeries journaling – how to get past hard errors?

    We have stopped journaling on our test system (library driven). How can we get around the CPF4328 error - "Member (FILE) not journaled to journal *N'?

    ItsHerAgain30 pointsBadges:
  • Pagination in DB2 Z/OS

    I have a select query that returns 500000 rows. I need to display 100 rows per page. When the user navigates to next page, I need to display the rows between 100 and 200 and so on. I am using DB2 v10 and java. My query is taking long time to fetch the data even though I am fetching 100 rows at a...

    Vithal25 pointsBadges:
  • Configure on availability group for DBs

    Can I configure on Availability Group for few DBs, and then mirror with synchronous automatic failover in same SQL instance? Would that be possible?

    VaidyaSQL5 pointsBadges:
  • SQL0666 SQL query exceeds specified time limit or storage limit

    I have a web service using a iDB2 connection to return a Data Set. I am searching a large table on a partial string to find a portion of a serial number, I kept getting this SQL0666 error so I had a new LF created over the file on the i-Series side by the text field I am searching on and it now...

    ToddN200056,565 pointsBadges:
  • Is there any tool to validate the App consistency?

    Using the load generator I created, a random writes to SQL. With VSS and without VSS, I tried to create a backup. In both scenarios, I can able to make the SQL up and running without any issues. How do I produce the inconsistency in the backup, practical scenario when the Flush thaw will be useful...

    asvignesh5 pointsBadges:
  • Active Directory clients cannot use some software

    Hi Experts, We have an Domain controller (Windows 2008 R2)  installed with all AD group policy implemented. We are facing an weird issue that as we install SQL or Visual Studio 2012 or later one, these all software require option "Run As Administrator" to run all options incorporated in them. Now...

    MandeepSahani5 pointsBadges:
  • SQL insert error

    Hi, I am setting a process of creating a table and inserting data into it from another table. I created a table "example". When I run the SQL command insert into mylib/example select (some specific columns) from example2 where User = 'sqakxb'. It is throwing exception error. When I run the command...

    Kaustav0000165 pointsBadges:
  • Microsoft Access. Passing an ID/value to a subform. or between forms

    Hello Everyone. I am using MS Access 2000 I have a form (frm_cboclient)that has a combobox on it that I populate by querying a client table for clientID and client name. What I would like to do then is have a subform that will display all my order infomration from my order table, where the clientID...

    Gryphon0 pointsBadges:
  • Query/400 to give Column totals

    Hello, I would like to use Query/400 to provide a particular column total. I have about 6 fields and the final field is Inventory Cost that needs to be totaled in the end in the database file. I know it is easier over SQL, but I would like to know if this is possible.

    yaazhisai260 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.

Thanks! We'll email you when relevant content is added and updated.