• Problems with DB2 program

    I have a COBOL program that calls a db2 stored proc program. I get corrupted o/p records when reading the input file from CARTRIDGE. The same records, when copied to DASD, come out fine. Same code, JCL, etc. WTH! Is there a parameter that I need to pass to the system with PGM=IKJEFT01 to solve this?

    Golf25 pointsBadges:
  • Change password through JDBC

    hi can any one help me .. how to change a password reset/ change password through JDBC connections specifications: 1)we are going to change password from front end URL 2)we need to connect through Db2 database through JDBC connections

    Srinivas204415 pointsBadges:
  • DB2 table load JCL with current timestamp

    Hi I need load the data from the flat file to db2 table by dsnuproc (mainframe ) utility my file dont have the timestamp value but the cloum in the table col2 declared as timestamp not nulll caould you please help how do load current timestamp.Thanks in advance Regards Manju

    Manju25 pointsBadges:
  • SQL View over a table with members

    Hi all, I have an as/400 table(fileA) with several members, I need to create view that joins this to several other tables but but I need to only target one member in fileA. The other tables are all single member tables. I tried to create an alias over the table and then create the view but that is...

    Lpgast0 pointsBadges:
  • DB2 Stored Procedure V4R4 without ILE C/400

    We have an older iSeries running V4R4. We user Rumba/400 for AS400 access, and we've run into a problem using the Rumba ODBC driver for linked server access from our SQL server to our AS400 (The ODBC driver periodically fails when the linked server is used heavily). Because of this, we've been...

    MODMOD0 pointsBadges:
  • SAVACTWAIT time on SAVLIB, etc.

    Hi, Has anyone experimented with the SAVACTWAIT time on the SAVLIB command. The default on 120 second seems rather long. What I am looking for is a realistic value based on fact such as that if an object does not become available after 5 second the change that it will become available after 120...

    JohnDavid5 pointsBadges:
  • Is a DB on AS400 always DB2 ?

    Please, I want to know if possible : when we speak about a data base on AS400, exactly a data base used by RPG, is it allways a DB2 database ? Is AS400 a database. Is it the same as DB2/400 ? I hope to be clear enough. Sincerely

    Poussines50 pointsBadges:
  • Not compressed backup of databased with data compression enabled

    Hi All, currently recent databases version comprise features of data compression for storage optimization such as Oracle Advance Compression or DB2 Compression. My question is regarding backup of these databases with compression enabled when there's already a compression/deduplication hw product...

    Aleac5 pointsBadges:
  • Convert cpu time into MIPS

    How to convert cpu time into MIPS ? I would like to convert cpu time of A address space into MIPS. Thanks

    Thrhym0 pointsBadges:
  • Julian to Gregorian Date Conv. in DB2 Web Query

    I have a julian dates stored in the format YYDDD numeric, 5 positions, zero decimal. How do I convert to a true Gregorian date in DB2 Web Query for iSeries?

    Screechtx0 pointsBadges:
  • Transform DB2 to XML from AS/400

    I have been requested to create XML files from AS/400 DB2 files to be used to update data on a client's web server. I have looked at IBM's XML Toolkit for iSeries, but the examples are all about parsing XML input and nothing about creating XML from native AS/400 database files. Is there something...

    LBurkett99830 pointsBadges:
  • “map drive” IFS

    Hello, We have a ?LAN without any server Windows OS in it? , so everybody is a client (with fixed IP). The only ?server? we have, is our iSeries i5 (V5R3) with iSeries Access(CA) installed (also on the clients). We cannot ?map drive? the IFS f.e. root with \QS6555A8Aroot (or anything else on the...

    Hahajokes5 pointsBadges:
  • DB2 or Websphere- for good career in IT

    Out of IBM DB2 and IBM Websphere, which is a better technology to study in terms of career option????

    AmanSE5 pointsBadges:
  • Print Image File in iSeries

    Hi, I would like to ask for help to use the data type field GRAPHIC in iSeries. Can I save an image file into this field type. If so, how do I do this? I have tried but it always shows an error of character conversion not valid. Please help. Regards, Tony Tam

    Tonytam0 pointsBadges:
  • Beginning DB2 programming in mainframes

    how to start db2 programming in mainframes detailed

    Practical5 pointsBadges:
  • iSeries accessibility to VB.NET, ASP 2.0/3.0 ,NET programmers in Visual Studio

    My shop does not have WebSphere but does have a sizeable VB.NET team using the MS Visual Studio. They need access to the iSeries files in DB2/UDB - real-time. We already thanks to me have a number of batch/DTS package type transfers. Do any of you know packages that can make the iSeries files...

    JohndeCoville0 pointsBadges:
  • Deleting journal receivers

    HI, When I try to delete a journal receiver that hasn't been saved, I get the "never fully saved" message even though I'm using DLTOPT(*IGNINQMSG) Does anyone have a piece of code that will get rid of receivers no matter what? E.G. not saved, remote, attached...... Thanks

    Xixones0 pointsBadges:
  • Importing/copying external EBCDIC files to DB2 on iseries

    This seems kind of obvious, but we can't figure it out. Another company has sent us (via email) an EBCDIC file and we want to load it on to our iseries. What's the ticket? We've tried CPYFRMPCD and a couple of other things, but we get conversion errors? Any thoughts out there?

    Esmith590 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:
  • Is there a 3rd party tool (or native option) for retrieving data from DB/2 into an Excel spreadsheet complete with pivot tables?

    Is there a 3rd party tool (or native option) for retrieving data from DB/2 into an Excel spreadsheet complete with pivot tables? This would likely be done via a web browser interface such as Joomlah.

    Restart15 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