• Synon (Migration)

    Dear Friends, We are in a plan of migrating system to some other technology like Java/.NET etc. Please find the details and questions below. Information about the current System: Synon (CA -2E) 8.5 Version Few modules the source is getting generated in COBOL and other in RPG Database we using...

    BibinG20 pointsBadges:
  • record locking in As/400

    HI can anybody tell me about how to handle the Record locking situation when more than one user tries to access the same record in a physical file....?

    ten20081,150 pointsBadges:
  • DB2 for Z/OS and DB2 for LINUX / WINDOWS/ AS400

    I have around 5 years of IT experience in Mainframe and Midrange operations. As I'm more intersted in database administration, recently I did IBM DB2 9 Fundamentals certification and also IBM Mainframe application development course ( JCL,VSAM,COBOL,DB2,CICS) but it was 5 years back. I want to go...

    Sarada1115 pointsBadges:
  • String Aggregate Function

    I need a report that provides an aggregate of a string column - in this case a concatenation of the values in a comma separated string. There is no such DB2 aggregate function that does this. A stored procedure (or possibly a customer aggregate function?) seems the only likely way to accomplish...

    Mgemmill5 pointsBadges:
  • Comparing DB2 between AS/400 and mainframes

    How different is DB2 for AS/400 and for mainframe? For example, the high-level DB2 administrative privileges. Catalog names such as SYSADM, SYSCTRL, SYSOPR, DBADM, PACKADM, DBMAINT, DBCTRL, or catalog views such as SYSCAT.DBAUTH, SYSCAT.COLAUTH, SYSCAT.TABAUTH etc, are they using the same names for...

    Dwiningsih25 pointsBadges:
  • Compare files in AS400

    When i compare two files using CMPPFM command, i am getting message as request failed. This is because files were having huge volume of data. It was showing file exceeds 112498 records. Is there any other way to compare files of large volume of data in AS400. Please let me know.

    Thotts45 pointsBadges:
  • How to sort a db2 table column, containing date stored in char format.

    i have a column which is not Y2K complaint, the values are stored in char format like ddmmyy ( i know its totally dumb), i need to sort based on ascending or descending order.  051193 -> 5 nov 1993  140308 -> 14 march 2008  141211 -> 14 december 2011   Now how do i sort this column...

    Maverickgiant40 pointsBadges:
  • AS400 – DB2

    We have CMPPFM command to compare Physical File member. Is there any way to compare logical File members in AS400? I want to compare 1 multi format logical file in 2 Libraries? How to do that?

    rajeshece1,215 pointsBadges:
  • DB2 Process automatically Shutdown

    At  our site using IBM DB2 database there some problem with our DB2 Database services stop automatically .Error log  shown the  DB2 PROCESSES ASSOCIATED WITH THIS INSTANCE HAVE BEEN SHUTDOWN. Thanks, Nilesh

    Linuxroot35 pointsBadges:
  • Can we change length of CSV File

    Hi guys, I have a CSV format file in my database which is used for Adhoc reporting. Now, I need to increase the legnth of that file. I am trying to increase using CHGPF command, But I wasnt able to do the same. Will any one of you suggest me the way for increasing the legnth of CSV file?

    deepu93213,605 pointsBadges:
  • Inserting and viewing of Chinese characters in DB2400

    Dear All, We are trying to insert Chinese characters into an AS400 PF. We originally had the CCSID of the PF field as 13488, The job CCSID being 65535 HOWERVER when we are trying to input characters, it is taking as ????????? Later, we careated a new file - with CCSID 1200 and still the same thing...

    Vkm5 pointsBadges:
  • SQL equivalent of GRTOBJAUT using Authorization List

    Using SQL script, how does one grant object authority to a table using an authorization list?   This fails because MyAutList is not a *USRPRF:  grant all on table mylib.mytable to MyAutList This works, but is not what I need: grant all on table mylib.mytable to Public 

    DavidGar15 pointsBadges:
  • DB2 Tuning link or manual for AS400

    Hi, In the company I work for we have a requeriment for tuning DB2 in as400. We still don't know the server release, but I wanted to start searching for any documentation about that. I will appreciate any link or suggestions. Thank you. Regards.

    Mariodlg2,790 pointsBadges:
  • SQL Update Set: Higlight Customers without Invoices, Update and join Tables?

    Hello, I am not sure how to do this with an SQL Update Set statemet: I have a table customers and I have related invoices. I would like to set one field to "not active" in the customer table that did not receive invoices since 2008. I can "Select" the corresponding records in the customer table...

    Cavallino30 pointsBadges:
  • CPF9999

    What CPF9999 does?

    Kar425 pointsBadges:
  • AS400 – Physical Files

    Hi I have some qusetion in AS400 How can we convert rows into columns and columns into row for a PF in AS400. Please send me the coding for this requirement. Thanks

    iiiiiiiiiiiii335 pointsBadges:
  • Boomi using JDBC to access DB2 in AS/400

    Want to use Boomi to access JDE DB2 What do I need to define on AS400?

    APMMRE5 pointsBadges:
  • AS/400 Error: RRN() does not start from 1, but starts from number of rows deleted + 1 db2, v5r4m0

    i'm trying to populate a field in A table with the row number using rrn(tablename). the first time if i insert 4 rows then the id is 1,2,3,4 as required. if i delete the rows and try the insert again the rrn() does not return the same so 1,2,3,4 but returns 5,6,7,8 (that is the nr of rows deleted +...

    Elai45 pointsBadges:
  • create xml content from as/400 db2

    Hi, wonder if these xml functions (XML2CLOB, XMLELEMENT, XMLATTRIBUTES, XMLAGG, ...) can be used in db/400 -- as/400 V6R1M0, if yes, any sample code? of not what else I can use to generate xml content from db2 queries? Any answer is appreciated.

    Jluo1235 pointsBadges:
  • 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:

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