• Migrating from AS/400 to SQL Server

    We have an AS/400 that no one in our agency knows anything about except that it has been running for a few years and the data needs to be removed from the AS/400 to another platform, either DB2 or SQL Server. I have read that a SQL ssis package can be used to migrate the data - I need to know what...

    Dharder15 pointsBadges:
  • Responsibilities of DB2/400

    Hi, Being an AS/400 development/admin guy what are the roles and responsibilites of DB2/400(DB/400 ?) on daily basis.  What could be the  maintenance activities. I'm just curious about to know...waiting for your valuable comments..    

    qmaster1,675 pointsBadges:
  • DB2 physical file

    how we can create View with Key to more than one PF in Diffrance Lib exsample LIB                         PF File Name ============================= Lib1                         Custom             (( for HeadOffice ))...

    Hodish40635 pointsBadges:
  • Jreport problem – floating point literal

    hi! I'm new here! I have a report and this is connect to db2/as400. When I compile i have the next error "[SQL0410] Floating point literal 2.00805121133377101E18 not valid. Cause...." I don't know what is happenning. The query I run in other program and this is right, so I think is something with...

    LouIT5 pointsBadges:
  • Version of DB2 running on AS/400

    I need to know the version of DB2 runing on AS400, do you know how can I to get it?

    GeLaLo10 pointsBadges:
  • How i can create LF View To More than One Library?

    how i can create LF View To More than One Lib.

    Hodish5 pointsBadges:
  • Enherit column attributes when ALTERing column

    I have this: 1. A field-reference table (fieldref): CREATE TABLE mylib/fieldref ( A CHAR (10) NOT NULL WITH DEFAULT, B CHAR (10) NOT NULL WITH DEFAULT, C DECIMAL (7 , 5) NOT NULL WITH DEFAULT, PRIMARY KEY (A)) 2. A data table (myfile) created on the basis of the above fieldref table: CREATE TABLE...

    DanTheDane2,555 pointsBadges:
  • iSeries Update Values in a Table Based on Values in Two Tables.

    I want to update a Client Category Code in the Client_Table where the Client has a specific Country Code AND and the Clients VAT No is Blank, Which is in The Client_Account Table in another Library. The Matched Records are [LIBRARY1]FILE1.CLLDRS and [LIBRARY2]FILE2.ADLDRS So Update...

    Sconna2325 pointsBadges:
  • SNDDST to include User Name with the Error

      I would also like to get the USER Name that has the MSGW  in this CL... How can I do that?   SNDDST TYPE(*LMSG) TOINTNET(('user@tmyCompany.com') DSTD('***- Message in ACTIVE JOBS -***') LONGMSG('Message waiting in Active Jobs ') IMPORTANCE(*HIGH) PTY(*HIGH)

    Jaymz69765 pointsBadges:
  • Finiding the PF name

    Hi Guys, I am stuck in here to find the physical file name, I know the alternate name of the PF, is there any procedure to find out the original PF name using the alternate name? Please help

    vssagar70 pointsBadges:
  • Recovery of PF data from journal

    Hi All, Consider the case, some one has accidentally deleted all records in a PF and that file is Journaled, Is it possible to recovery the records from receiver attached. if so, how can we do it?

    Kar425 pointsBadges:
  • How would we know which index is been used during Native IO reads or SQL query execution happens on that file during program is being run?

    For example on an as/400 Data base file, some 10 indexes are created? How would we know which index is been used during Native IO reads or SQL query execution happens on that file during program is being run?

    TNKR130 pointsBadges:
  • Update done in physical file which does not reflect in Logical file

    Hello All,   1.I need to know when an update happens to Physical file the updates should not reflect in the corresponding logical file. Please let me know what needs to be done for this.  2. How will we update a field in a physical nd not the whole record in RPG IV. Please explain with an...

    Ponsasikumar5 pointsBadges:
  • Releasing lock in AS/400

    how to find which record is locked and who locked that record.how to release the lock by ourselves.please explain in detail.i'm new to as/400.

    Kaly470 pointsBadges:
  • Prevent record lock scenario with AS/400 ?

    Suppose 2 users are accesssing the same record in a file.User 1 tried to update the record and while doing so he did not log-off from his update screen,while the user tries to do inquiry on that same record. As a result there will be a record lock situation.How to prevent this scenario ? i need...

    Supriyoas400130 pointsBadges:
  • using %char and removing leading blanks

    I have a 6 pos serial number, ex(000022) that I need to CAT onto a qualifier of UN. so the final result should be UN22. I would like to do this using %char. I thought I could do it in one line, but I am having issues with not being able to remove the leading blanks. My result ends up being...

    Dobie80 pointsBadges:
  • DB2 data over web browser

    Our solutions resides in System i and its all are internal developed systems. Our applications are Logistics business driven and now we have the need to publish these informations over web for view by customers. HOW do i do that.. and what should i consider..

    bsathia20 pointsBadges:
  • Connecting to morethan one AS400 DB2 Remote Databases using SQLRPGLE

    I have requirement to connect more than one AS400 DB2 remote/distributed database to retrieve the Quantity by using SQLRPGLE Program. Found working with one remote DB, Retrieving the quantity & other Remote DB is getting connected, but while executing the SQL query it says SQL Package not found....

    AS400DB2DBA5 pointsBadges:
  • How can I list users who accese DB2/400 via ODBC or data transfer of iSeriesAccess

    We have many users who access DB2/400 database via ODBC or data transfer of iSeriesAccess. Are there any way to list those users from the accounting journal or audit journal?

    ISHII5 pointsBadges:
  • controlling C D I R options in the workstation message queue.

    Hello All, Could youplease tell me how to control the C D I R options via programs. I mean that i do not want R to appear in screen and the functionality is automatically done . Can it be possible. If yes please tell in detail and if not then what is the reason.  

    Bigdumbo25 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.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following