Questions & Answers

  • Exporting DB2 file without DB2 server

    Here's the issue - I was given a DB2 file but I don't have a DB2 server. I need to export all of its data without the server. Is there a tool for this? It doesn't matter if it's for Linux or Windows. Thanks very much.

    ITKE970,045 pointsBadges:
  • Finding name of DB2 table primary key

    Hello, Can I find the name / value of a DB2 table's primary key? I already tried SYSCAT but that didn't work. I'm using DB2 version 10. Thank you.

    ITKE970,045 pointsBadges:
  • 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,045 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,045 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,045 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,045 pointsBadges:
  • OST files

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

    Vsvajgl5 pointsBadges:
  • Can I convert .OST to .PST file?

    I need to convert .OST to .PST file. I found and used some ost to pst converters but without result. How to find or where find reliable ost/pst converter or is it possible to solve this issue manually? Thanks.

    lstaff83615 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:

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