+ Post New Thread
Page 10 of 10 FirstFirst ... 8 9 10
Threads 181 to 200 of 200

Forum: General

If you want to discuss a topic not covered in the other database forums, this is where to post.

  1. Can a Trigger be placed on a IFS file?

    I'd like to know when a stream file in an IFS directory has changed. When it has, I'd like to run an AS/400 job that reads the IFS file, imports it...

    Started by Guest.Visitor‎, 12-13-2002 12:13 PM
    • Replies: 0
    • Views: 418
    Guest.Visitor
    12-13-2002, 12:13 PM Go to last post

  2. Maximum number of Logical Files?

    I can remember working with a system where a CASE tool was used. The tool (which I shall not name. . . . . . . .O.K. - Synon) routinely generated...

    Started by David Abramowitz‎, 12-11-2002 08:28 AM
    • Replies: 6
    • Views: 1,085
    nycsusan@hotmail.com
    12-13-2002, 12:06 PM Go to last post

  3. SQL - Session saved statements

    Just sign on as that user at that workstation and then exit SQL with option 4 to save session to a file? Otherwise this command will dump the session...

    Started by G.Gaunt‎, 12-05-2002 04:54 AM
    • Replies: 2
    • Views: 907
    Guest.Visitor
    12-05-2002, 05:24 AM Go to last post

  4. SQL Statement

    SELECT substr(tmcode,3,1) as tmhold FROM mailfile WHERE substr(tmcode,3,1) = 'B' If you want to select all of the other fields too, then: SELECT m.*,...

    Started by Guest.Visitor‎, 12-03-2002 06:46 PM
    • Replies: 7
    • Views: 1,053
    Diane Mueller
    12-06-2002, 01:39 PM Go to last post

  5. Journal "Before" Images

    You can do a DSPFD, type journ on the find line, do F16...this will position you to the journal information. Journal images should be *both. Or you...

    Started by Guest.Visitor‎, 12-03-2002 05:07 PM
    • Replies: 2
    • Views: 379
    Guest.Visitor
    12-04-2002, 03:56 AM Go to last post

  6. I need a smarter Trigger, or Trigger needs a smarter me..

    There are two options: 1) Do not let the trigger insert new records into the PF the trigger is triggering. I think that is the normal procedure. 2)...

    Started by coteijgeler@chello.nl‎, 11-27-2002 01:06 AM
    • Replies: 9
    • Views: 852
    Guest.Visitor
    12-02-2002, 10:36 AM Go to last post

  7. Where are the triggers??

    You may try PRTTRGPGM command

    Started by ukpi1b‎, 11-26-2002 07:11 AM
    • Replies: 5
    • Views: 1,189
    David Abramowitz
    11-27-2002, 10:49 AM Go to last post

  8. Syntax question for QPNQRYF command in CLP

    Try this: OPNQRYF FILE((APPINVE)) QRYSLT('DIV = %VALUES("35" "46") *and DSBDAT = %RANGE(' *tcat &RANGE1 *tcat ' ' *tcat &RANGE2 *tcat ') *and MODIFY...

    Started by bcarver@mysticstamp.com‎, 11-21-2002 09:41 AM
    • Replies: 9
    • Views: 1,037
    dalejanus
    12-09-2002, 11:12 AM Go to last post

  9. Duplicate triggers in V5R1

    I think we need a full-panel "WRKPFTRG" utility from IBM to help us manage this stuff better.

    Started by G.Gaunt‎, 11-13-2002 05:32 AM
    • Replies: 3
    • Views: 1,093
    jquinlan
    11-18-2002, 01:21 PM Go to last post

  10. Is there already a free utility for this?

    It is not as comprehensive as you would like, but you could try the CMPPFM command. It is free, and included with OS/400. Dave

    Started by David Abramowitz‎, 11-08-2002 10:00 AM
    • Replies: 1
    • Views: 586
    michaelr@railcarmgt.com
    11-08-2002, 12:30 PM Go to last post

  11. Different result between CPYF and CRTDUPOBJ

    Occasionally we use a utility to restore deleted records from a database file, to fix a problem or just for research. Sometimes for a file we want to...

    Started by michaelr@railcarmgt.com‎, 11-08-2002 08:58 AM
    • Replies: 1
    • Views: 2,022
    michaelr@railcarmgt.com
    11-08-2002, 08:58 AM Go to last post

  12. Maximum Size of Journal Receiver?

    Anyone know what the max size of a journal receiver is (in MB, GB, or whatever)? I created one using the threshold parameter of *NONE but a program...

    Started by Guest.Visitor‎, 11-01-2002 08:19 AM
    • Replies: 1
    • Views: 732
    S.Mildenberger
    11-01-2002, 08:51 AM Go to last post

  13. Suppressing printout from RUNSQLSTM command

    Does anyone know how to suppress the output that you get when you run a SQL statement using the RUNSQLSTM command? I have a SQL statement stored in a...

    Started by michaelsoucy@netzero.net‎, 10-28-2002 08:30 AM
    • Replies: 0
    • Views: 616
    michaelsoucy@netzero.net
    10-28-2002, 08:30 AM Go to last post

  14. Modifying SQL Stored Procedure

    There are various options available to modify stored procedures on the AS/400 depending on what OS release you are at. Whether you execute the CREATE...

    Started by Guest.Visitor‎, 10-14-2002 10:43 AM
    • Replies: 4
    • Views: 2,941
    Ericksco
    07-11-2003, 11:55 AM Go to last post

  15. Grouping on a Date with Different 24 Hrs Clock

    This can be done in Crystal Reports. You can specify a range value to group data. Dave

    Started by David Abramowitz‎, 10-09-2002 01:03 PM
    • Replies: 3
    • Views: 530
    David Abramowitz
    10-10-2002, 07:25 AM Go to last post

  16. Pin a database file into memory

    I remember that there is a way to force a file to reside in memory on the AS/400. I just can't remember the command to force that to happen. Does...

    Started by JohnFox‎, 10-04-2002 06:28 AM
    • Replies: 1
    • Views: 760
    JohnFox
    10-04-2002, 06:28 AM Go to last post

  17. SQL Case

    In your SELECT CASE.... and WHERE clauses CDE has not matched selection criteria: '100','200', '300' and '00100', '00802'... If '00100', '00802'.. is...

    Started by ukpi1b‎, 10-03-2002 12:06 PM
    • Replies: 5
    • Views: 735
    Guest.Visitor
    10-08-2002, 11:19 AM Go to last post

  18. Keyed Physical File

    Hi bibarnes. I too have heard this warning throughout my long and bland career. :) I have had the issue with one file in nearly twenty years having...

    Started by Guest.Visitor‎, 09-30-2002 12:37 PM
    • Replies: 5
    • Views: 863
    bibarnes@yahoo.com
    10-01-2002, 03:49 AM Go to last post

  19. TechTip: DB2's CONNECT BY Simplifies Recursive Processing

    Started by S.Lennon‎, 12-31-1969 06:33 PM
    • Replies: 0
    • Views: 56
    S.Lennon
    12-31-1969, 06:33 PM Go to last post

  20. TechTip: DB2's CONNECT BY Simplifies Recursive Processing

    Started by S.Lennon‎, 12-31-1969 06:33 PM
    • Replies: 0
    • Views: 405
    S.Lennon
    12-31-1969, 06:33 PM Go to last post
+ Post New Thread
Page 10 of 10 FirstFirst ... 8 9 10

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