+ Post New Thread
Page 5 of 17 FirstFirst ... 3 4 5 6 7 15 ... LastLast
Threads 81 to 100 of 334

Forum: SQL

Information about SQL programming

  1. Order By... in a Join

    What occurs to me: 1. Check the Query Optimizer messages - maybe it'll suggest an index that would work. 2. Create the resultset as a table, then...

    Started by Guest.Visitor‎, 05-04-2006 09:34 AM
    • Replies: 2
    • Views: 1,335
    TheQuigs
    05-08-2006, 02:12 PM Go to last post

  2. SQL Noob needs help with DELETE

    DELETE FROM fileA WHERE NOT EXISTS (SELECT 1 FROM fileB WHERE orderA = orderB AND releaseA = releaseB) It might be a good idea to run the above as a...

    Started by Guest.Visitor‎, 04-14-2006 05:17 AM
    • Replies: 2
    • Views: 684
    Guest.Visitor
    04-18-2006, 09:35 AM Go to last post

  3. Running SQL Statements in a Batch Job

    Do a search on RUNSQLSTM. Chris.

    Started by Guest.Visitor‎, 03-28-2006 09:44 AM
    • Replies: 7
    • Views: 5,288
    mpavlak
    04-03-2006, 06:02 PM Go to last post

  4. SQL Line Counter function

    Recently I saw a function that creates a line counter. I would like to do something similar to the faolowing: Select LineCount(5000), Value from...

    Started by T.Grove‎, 03-24-2006 06:16 AM
    • Replies: 1
    • Views: 1,128
    Rafy
    03-24-2006, 06:16 AM Go to last post

  5. sql help, please

    ok ... i'm developing a report utilizing sql. i have some sum functions that i'm using. if i have these straight in the select clause everything...

    Started by quilaho‎, 03-21-2006 07:43 AM
    • Replies: 1
    • Views: 536
    Guest.Visitor
    03-21-2006, 08:11 AM Go to last post

  6. SENSITIVE CURSORS???!!!!

    hi, i have encountered this strange problem: an SQLRPGLE create a cursor DYNAMIC SCROLL and execute a select making UNION like this: "select * from...

    Started by lucaguatieri‎, 02-01-2006 08:53 PM
    • Replies: 1
    • Views: 775
    schmitty
    02-01-2006, 08:53 PM Go to last post

  7. Embedded SQL in a procedure

    I have an procedure in an RPG program that runs an SQL statement to return a value. My question pertains to performance. Will closing the sql cursor...

    Started by schmitty‎, 02-01-2006 08:18 PM
    • Replies: 0
    • Views: 476
    schmitty
    02-01-2006, 08:18 PM Go to last post

  8. Access paths using dynamic SQL vs. RUNSQLSTM

    PEZ wrote: > I expected it to use a logical called MBSHPL01 which is keyed by > MBNMNO. > Same for the other ITEML01 which is keyed by DMNMNO....

    Started by Guest.Visitor‎, 01-30-2006 10:23 AM
    • Replies: 2
    • Views: 977
    PEZ
    01-30-2006, 05:27 PM Go to last post

  9. Access to SQL Stored Procedure Results Set from RPG

    I have a need to call an SQL Stored Procedure from RPG that will access the a SQL Stored Procedure that returns a Result Set. The stored procedure I...

    Started by Guest.Visitor‎, 01-27-2006 10:58 AM
    • Replies: 0
    • Views: 488
    Guest.Visitor
    01-27-2006, 10:58 AM Go to last post

  10. SQL statement INSERT INTO db2 file from an Access Table

    If the db2 file is defined as a linked table within the Access DB you would be able to do this. INSERT INTO MYLIB_MYFILE (SELECT * FROM myAccess...

    Started by Guest.Visitor‎, 01-27-2006 03:42 AM
    • Replies: 6
    • Views: 2,797
    Diane Mueller
    01-27-2006, 10:28 AM Go to last post

  11. How I can compare two rows?

    José Juan wrote: > SELECT MIN(tableName) as TableName, id, col1,col2,col3 > FROM > ( > SELECT tablea as tableName,a.id,a.col1,a.col2,a.col3 > FROM A...

    Started by Guest.Visitor‎, 11-21-2005 08:03 AM
    • Replies: 1
    • Views: 1,513
    Jose Juan
    11-21-2005, 11:30 AM Go to last post

  12. SQL0181 on upload from PC

    Check out the hex values of the two fields in question. Dave

    Started by David Abramowitz‎, 11-17-2005 02:35 AM
    • Replies: 2
    • Views: 707
    mjawcock
    11-17-2005, 09:35 AM Go to last post

  13. SQLDA setup for use with the OPEN Statement

    Not a working sample, but some snippets and reminders. For each value to pass (your parameter marker you have to fill an SQL_VAR element in the array...

    Started by coteijgeler@chello.nl‎, 11-13-2005 11:49 PM
    • Replies: 4
    • Views: 1,040
    Guest.Visitor
    11-15-2005, 10:21 AM Go to last post

  14. Create Index Question

    Is it possible to run the create index statement which will join 2 separate physical files together? I'd like to set up a permanent index which joins...

    Started by Guest.Visitor‎, 11-08-2005 01:27 PM
    • Replies: 0
    • Views: 253
    Guest.Visitor
    11-08-2005, 01:27 PM Go to last post

  15. TechTip: A Couple Cool Cross Joins

    ** This thread discusses the article: TechTip: A Couple Cool Cross Joins ** Kevin, The article was an interesting read and I did pick up a few...

    Started by M.Savino‎, 10-13-2005 07:42 AM
    • Replies: 4
    • Views: 2,213
    MCWebsite.Staff
    10-17-2005, 05:50 AM Go to last post

  16. Performance issue in embeded SQL RPG

    My client has recently upgraded to OS/400 V5R3.The embeded SQL rpg programs are runing very slow on v5.3 when compare to previous version.Can any one...

    Started by arush_arya‎, 10-07-2005 04:39 AM
    • Replies: 1
    • Views: 1,607
    gradford@krispykreme.com
    10-07-2005, 04:39 AM Go to last post

  17. SQL Create Procedure Fails with SQL0679 (joblog CPF325E)

    BCSleeth wrote: > When I look at the joblog, I notice a goofy error: > > - CPF325E Uncommitted changes pending for file XXX in library YYY. Brian, In...

    Started by Guest.Visitor‎, 10-04-2005 06:50 AM
    • Replies: 5
    • Views: 1,910
    Guest.Visitor
    11-28-2005, 06:36 AM Go to last post

  18. Group By results into a temporary table

    Create the table in mylib usinf iseries naviogator or the CREATE statemnt in STRSQL. Then you can compile your program. After it is compiled (and...

    Started by bibarnes@yahoo.com‎, 09-16-2005 04:56 AM
    • Replies: 3
    • Views: 1,354
    T.Grove
    09-23-2005, 03:41 AM Go to last post

  19. Tables left open

    I have a program that accesses various tables through cursors. there is one table that is not; Select Repold Into :Rplstr# :Ind_Var1 From Strp0050...

    Started by bibarnes@yahoo.com‎, 09-15-2005 06:47 AM
    • Replies: 0
    • Views: 522
    bibarnes@yahoo.com
    09-15-2005, 06:47 AM Go to last post

  20. Totally dynamic embedded SQL

    The prepared statement must be "Described" into a data structure from IBM called the SQLDA. As each row is fetched you can use the information in...

    Started by K.Forsythe‎, 09-14-2005 04:28 AM
    • Replies: 4
    • Views: 2,494
    johnfoldager
    03-09-2006, 04:59 AM Go to last post
+ Post New Thread
Page 5 of 17 FirstFirst ... 3 4 5 6 7 15 ... LastLast

Thread Display Options

Use this control to limit the display of threads to those newer than the specified time frame.

Allows you to choose the data by which the thread list will be sorted.

Order threads in...

Note: when sorting by date, 'descending order' will show the newest results first.

Icon Legend

Contains unread posts
Contains unread posts
Contains no unread posts
Contains no unread posts
More than 15 replies or 150 views
Hot thread with unread posts
More than 15 replies or 150 views
Hot thread with no unread posts
Closed Thread
Thread is closed
Thread Contains a Message Written By You
You have posted in this thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Forum Rules