Questions & Answers

  • Connecting .NET to AS/400 using ODBC

    We are connecting .NET to AS/400 using ODBC when we call an SP in AS/400 from .NET, we are getting the null output. What might be the problem.??

    bharathtata30 pointsBadges:
  • DB2: Limitation on SQL statement characters

    On DB2, is there a limitation to how many 'characters' can be passed to my database? My friend told me that there was in older versions but I'm on the latest version so I wanted to confirm this. Thank you.

    ITKE970,655 pointsBadges:
  • Converting DB2 Timestamp to UTC milliseconds

    I'll get right to my point - would I be able to convert my DB2 timestamp into UTC milliseconds? Is there a function to do this? And yes - I'm currently doing this in SQL.

    ITKE970,655 pointsBadges:
  • How to convert DB2 timestamp into Unix timestamp

    Hi experts, I've been trying to convert my DB2 timestamp into a Unix timestamp but haven't had any success. Is there a built-in function to do this? SQL command? Thank you.

    ITKE970,655 pointsBadges:
  • GL pointers T24 Globus

    I need help. Where can I find GL pointer/mapping in T24 Globus?

    srithea365 pointsBadges:
  • PCOMM: FindFieldByText always returns nothing

    FindFieldByText does not work. pcomm 6.0 version I wonder why the FindFieldByText always return nothing even if I changed the find string, and the find string exists in the session. Anyone met the same problem? I have tested the FindFieldByRowCol method, that is okay. addition:Both English and...

    xiaogang5 pointsBadges:
  • How to split and later reunite a large MS SQL table

    Sir I am stuck in a logic. I have dynamic tables. Let's say one large data Big_Table is stamped with profile 1,2,3,....n So I create table profile1, profile2,... profilen (example profile1 :- select * from Big_Table where rule = profile1) table data example :- table_profile1 transaction_id profile...

    AshishMishra95605218565 pointsBadges:
  • iSeries SQL0904 Resource limit exceeded

    I have written RPG/ILE stored procedures to validate and write data to various physical files with data extracted from MSSQL tables using SSIS and MS Visual Studio 2013 and utilizing the Native OLE DBIBM DB2 for i IBMDA400 OLE DB Provider. My problem the extract job fails when trying to import...

    JustJamesG5 pointsBadges:
  • List jobs from iSeries JobScheduler

    How do I list all jobs in iSeries JobScheduler?

    gh2808hoc5 pointsBadges:
  • How to see DB2 definition view

    Does anyone know if I'm able to see the definition of a view in DB2? Is there a SQL query I can use? I already tried this code: SELECT * FROM SYSCAT.VIEWS But I'm getting an error message saying it's an undefined name. What can I do?

    ITKE970,655 pointsBadges:
  • OST files

    Why would ost files be created if the cache mode is off for outlook 2007?

    Vsvajgl5 pointsBadges:
  • Save or Play SWF file on computer

    How do I save or play a SWF file on my computer?

    MrC10205625 pointsBadges:
  • CWBDB0036 / SQL0204 Error when using data transfer to IBMi

    A single user gets the error; CWBDB0036 - Server returned SQL error SQL0204 - "filename" in *CURLIB type *FILE not found. We recently upgraded our OS to V7R1 and since the upgrade we have a user that is unable to run a .dtt to transfer a .csv into an existing file / member on the 400. I even...

    MWeales25 pointsBadges:
  • Allow user to run AS/400 commands

    I have limit capability enabled for a user, but I need to enable him to run few commands, which is not able to because of Limit capability parameter set as *yes, Can I  get him to execute certain commands in spite of limit capability parameter set as *yes. How can I do it?

    JohnsonMumbai1,425 pointsBadges:
  • Why does my URL change when I click the “Mail” icon in yahoo?

    While using one of my yahoo accounts, I find that when I click on "mail", the url changes; one of my received e-mails, should not have a security code attached to it in the subject line and the nature of the e-mail is "sex-toys", something I would not be interested in.

    Pukiom215 pointsBadges:
  • RPG vendors compatibility

    Is it possible to manipulate a RPG program of one vendor to make it compatible with another RPG vendor?

    VijayMehta5 pointsBadges:
  • CL SNDUSRMSG to PF

    Hi All, I am new to CL/400, please help me to understand it. Below is the simple CL program. PGM DCL VAR(&A) TYPE(*DEC) LEN(4 0) VALUE(10) DCL VAR(&B) TYPE(*DEC) LEN(4 0) VALUE(20) DCL VAR(&C) TYPE(*DEC) LEN(4 0) DCL VAR(&D) TYPE(*CHAR) LEN(6) CHGVAR VAR(&C) VALUE(&A +...

    sivaknagula55 pointsBadges:
  • Best automation tool for insurance project

    Which is the best testing tool for project based on insurance? And How?

    MIK201645 pointsBadges:
  • RPGLE multi-file processing with no match fields

    I believe I have found a bug in the way that RPGLE handles primary and secondary files with no match fields. My program will not process the primary file if there are no records in the secondary file; but it will process the secondary file, if there are no records in the primary file. RPG bug?

    Modiyooch760 pointsBadges:
  • Run DB2 queries on Linux machine

    I'm fairly new to DB2 - been working on for the past few months. I just installed DB2 on my local machine and I'm trying to run my queries through the terminal. This is a Linux machine. Whenever I try to run any queries, I keep getting this error message: SQL1092N "ROOT" does not have the authority...

    ITKE970,655 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.

Following