+ Post New Thread
Threads 1 to 20 of 20

Forum: Application Servers

Sometimes users have technical questions about application servers, and here is where they can find answers.

  1. Accessing Remote DB2/400 ondemand

    Hi friends. I have been asked if there is any function or software able to allow access remote files using SQL. I suggest using SQL CONNECT, DDM or...

    Started by canazco2‎, 05-10-2004 04:57 AM
    • Replies: 0
    • Views: 1,284
    canazco2
    05-10-2004, 04:57 AM Go to last post

  2. damage file

    Tiki, Been there, had this problem. Here's what I did, 1. CPYF the file to another name and location 2. Deleted ALL Lf's. 3. Deleted the PF. 4. CPYF...

    Started by Guest.Visitor‎, 05-12-2004 01:13 PM
    2 Pages •
    1 2
    • Replies: 15
    • Views: 7,200
    jking@apswaco.com
    06-25-2004, 05:56 AM Go to last post

  3. Can not find Function

    Maybe because the parameter types don't match? You've defined the parameters as INTEGER, but are calling it with PACKED fields. The system can find...

    Started by Guest.Visitor‎, 05-19-2004 11:43 PM
    • Replies: 2
    • Views: 1,683
    K.Forsythe
    07-02-2004, 06:52 AM Go to last post

  4. V5R2 support for RETURNed cursors in nested stored procedures

    Recent V5R2 PTFs support the return of result sets from nested stored procedures. This statement, from Registered Knowledge Base document 19693746,...

    Started by Guest.Visitor‎, 05-25-2004 12:47 PM
    • Replies: 0
    • Views: 1,280
    Guest.Visitor
    05-25-2004, 12:47 PM Go to last post

  5. Data Conversions- ASCII, UNICODE, EBCDIC

    In the DDS at the field level, define the field as CCSID(65535). This means "do not translate", use the hex value "as is". That should get...

    Started by Guest.Visitor‎, 05-26-2004 10:58 AM
    • Replies: 4
    • Views: 3,127
    Guest.Visitor
    09-22-2004, 06:43 PM Go to last post

  6. Multiple jobs processing same file

    Are any other jobs (by other users) running against this file at the same time? Dave

    Started by David Abramowitz‎, 06-02-2004 10:50 AM
    • Replies: 8
    • Views: 3,140
    asheesh_ks@infosys.com
    08-30-2004, 03:48 AM Go to last post

  7. Uploading/Sending Excel to AS/400

    I have an issue uploading Excel to AS/400 DB using Client Access Wizard. I usually get a data mismatch from cells row, column but when I look at the...

    Started by Guest.Visitor‎, 06-04-2004 01:46 AM
    • Replies: 1
    • Views: 1,595
    David Abramowitz
    06-04-2004, 01:46 AM Go to last post

  8. iSeries dB2 training

    Where is your company located?? If your company is in any states around Michigan, feel free to e-mail me and I can supply you a name of a...

    Started by Guest.Visitor‎, 07-01-2004 11:34 AM
    • Replies: 2
    • Views: 1,522
    K.Forsythe
    07-02-2004, 06:41 AM Go to last post

  9. Query Optimizer - us an explicit logical file

    Not to my knowledge. The ONLY effect that specifing a logical on an SQL statement makes, is that logical will definately be evaluated as a possible...

    Started by dacust‎, 07-12-2004 07:39 AM
    • Replies: 5
    • Views: 1,529
    dhinman@blinfo.com
    07-13-2004, 05:40 AM Go to last post

  10. Query Optimizer - logical file select/omit

    See response to SELECT SQL - Use of a Logical Use SQL to define indexes (probably better performance) and avoid use of Select/Omit logicals. There is...

    Started by solpssi@bellsouth.net‎, 07-13-2004 04:13 AM
    • Replies: 2
    • Views: 2,147
    dhinman@blinfo.com
    07-13-2004, 05:00 AM Go to last post

  11. create sort over PF in Qtemp

    If you are working on learning RPG - I would stick with that for now. However, if the file is being created in QTEMP, you should be able to have...

    Started by K.Forsythe‎, 07-15-2004 08:23 AM
    • Replies: 4
    • Views: 2,068
    Guest.Visitor
    07-15-2004, 08:43 AM Go to last post

  12. SQL Index

    An EVI helps the SQL query engine quickly find records when you specify a WHERE clause such as: SELECT * FROM filename Where field1 between 'A' and...

    Started by Guest.Visitor‎, 07-20-2004 07:59 PM
    • Replies: 5
    • Views: 4,001
    tswales
    07-22-2004, 07:47 AM Go to last post

  13. DB2 and trying to zip

    You may be getting "path not found" because the target path does not begin with a slash. DSPCURDIR to see where you are, CHGCURDIR to change....

    Started by Guest.Visitor‎, 07-29-2004 01:58 PM
    • Replies: 5
    • Views: 2,392
    mcreynolds99
    08-02-2004, 07:06 AM Go to last post

  14. Record info

    A specific record? Not unless a timestamp field is a part of the schema. Dave

    Started by David Abramowitz‎, 08-05-2004 02:21 PM
    • Replies: 2
    • Views: 1,423
    todd.lane@towneair.com
    08-05-2004, 03:49 PM Go to last post

  15. QDBSRVnn JOBs

    Does anyone know what these jobs are. Some of these jobs have taken lock on files and I am unable to end journalling on them. Please help.

    Started by asheesh_ks@infosys.com‎, 08-10-2004 01:30 PM
    • Replies: 1
    • Views: 1,802
    asheesh_ks@infosys.com
    08-10-2004, 01:30 PM Go to last post

  16. IFS Problem-Moving data from an AS/400 Folder to IFS NT share drive

    The code form my first message got scrambled. Please refer to this code to comment on this topic. <hr width=50 align=left>Code

    Started by John Polucci‎, 08-12-2004 01:54 PM
    • Replies: 2
    • Views: 2,081
    John Polucci
    08-13-2004, 04:51 AM Go to last post

  17. Adding DBCS capability to a current application

    Have partition setup with DBCS English as primary language and Japanese as secondary language. Want to use copy of current application that we use in...

    Started by brubakerm2‎, 08-24-2004 05:12 AM
    • Replies: 0
    • Views: 1,390
    brubakerm2
    08-24-2004, 05:12 AM Go to last post

  18. SQLDA Cache space reached size threshold limit

    I have seen this message before. I believe you have a RPG program with Embedded SQL which is Defined as ACTIVATION GROUP *NEW. Also you CLOSE Cursor...

    Started by solpssi@bellsouth.net‎, 09-15-2004 08:13 PM
    • Replies: 3
    • Views: 2,790
    solpssi@bellsouth.net
    09-22-2004, 06:17 PM Go to last post

  19. SQL and ILE

    Try encapsulating all the IO for a given file in sub procedures in a single service program. Use externally described multiple occurance data...

    Started by K.Forsythe‎, 10-05-2004 11:54 AM
    • Replies: 4
    • Views: 3,403
    K.Forsythe
    10-06-2004, 04:52 AM Go to last post

  20. Setup for Internet public can access the iSeries 170

    I have a iSeries 170 running V4R5. It is on a LAN that has Internet access provided by a IP provider. I need to know what is needed so the Internet...

    Started by jmartin‎, 02-04-2011 02:40 PM
    • Replies: 0
    • Views: 1,405
    jmartin
    02-04-2011, 02:40 PM Go to last post
+ Post New Thread

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