• Isolation level in iseries DB2

    How to set isolation level in iseries DB2? please reply.

    ORS5 pointsBadges:
  • Calling a URL length more than 200 from CLP

    Hi Techies, I would like to call a URL by passing some input values and retrieve some values from the results. 1. The URL lenght is more than 200, with special characters like % " < / > 2.I need to retrieve values from the particular website. Can u please help me out soon, its been getting...

    as400dev480 pointsBadges:
  • upload a pc file to as/400 iseries

    i wnat to upload a pc file of length 311 with 25 fields to iseries. I followed the steps specified in waltz400 on july 13th 2005.But i got a messags saying "CWBTF0005-data in this field incorrect(row1,colomn1)or does not match the pc data type" . sINCE THE FILE SIZE IS BIGGER I COULDN'T SAVE IT AS...

    Pc196425 pointsBadges:
  • Restoring Files

    Dear All, I want to set up a new test enviornment in our development box. A sub system has already been created. The following needs to be done. 1. Restore all physical files from PRDFLIB TO DEVFLIB 2. Restore all logicals from PRDLLIB to DEVLLIB .  The access path of the logicals(devllib) which...

    Knowledgeseekerone30 pointsBadges:
  • AS/400 FTP

    How to transfer the file to host using FTP Commands. I am connecting AS400 through CITRIX

    rajeshece1,215 pointsBadges:
  • QMF issue

    I have my QMF for windows version 8.1 Fix Pack 13, and I try to run this instruction INSERT INTO destination table SELECT * FROM origin table and every time I receive this error message: An error occurred while running the query. destrination table not valid for operation. (SQL code = -7008, SQL...

    Tiburonblanco80 pointsBadges:
  • DB2 indexes and Crystal Reports

    Is it possible to access DB2 (V5R1) indexes from the Visual Linking Expert screen in Crystal Reports(8) and if so how?

    AJ525 pointsBadges:
  • how to block update command when using STRSQL ( db2/400)?

    Hi People , I got several analysts that they must only use Select command through STRSQL prompt, I found I can block update command changing the object authority but I have loads and load of tables to change, is there any easier way to do that?

    Altino20 pointsBadges:
  • Error code 10: Function sequence error using CPYTOIMPF on AS/400

    I am using the CPYTOIMPF function on an AS400 to copy from one data base file to another. I want to end up with a .CSV file format. It worked once but now I get the following error: Message Id: SQ999999 Error occurred in SQL Call Level Interface. A procedure call encountered an error. The error...

    AS400 - Ask the Expert485 pointsBadges:
  • SQL script output to a file

    I am running ad hoc SQL scripts in iSeries Navigator (V5R4) and need to direct the output to a text file. Is there a way to do this? TIA... Steve B

    SBatSI415 pointsBadges:
  • Date Function AS400

    I need the Date function of DB2. Actually I want to subtract the Date however I have used the follwoing: select current date -1 from sysibm.sysdummay1; But It occures an error. Is there any way to subtract the date in the query. I am using iSeries DB2 AS400

    Mr. SEA130 pointsBadges:
  • Moving data from iSeries to DB2 on Windows

    I need to get data from a iSeries DB2 system to my Windows DB2 system. The DBA produced and sent me a savf file. How can I important that savf file into DB2?

    Claudek75 pointsBadges:
  • Giving Permission

    Hi, I am studing databases in a iSeries. All my objects are in librarie called DB1_T2. I need to give access to the professor so he can read all my data and execute my functions. How can I do that via the command line. Thanks a lot.

    Lv2eof5 pointsBadges:
  • SQL COMMAND to see table relation

    Which command I can use to get the relation between all tables in a system application?

    Arielmx5 pointsBadges:
  • Crystal Report Problem in VB6

    I am using VB6 with back ground Database DB2 AS400 iSerices and Crystal Report 9.0. When I Show the Report Its prompt me to enter password. I have tried to find the solution and found some thing about LogOnServer but every example is there for Crystal Report 7,8, and 8.5. I have tried to use...

    Mr. SEA130 pointsBadges:
  • LogOnServer Problem in Crystal Report

    I am using VB6 with back ground Database DB2 AS400 iSerices and Crystal Report 9.0. When I Show the Report Its prompt me to enter password. I have tried to find the solution and found some thing about LogOnServer but every example is there for Crystal Report 7,8, and 8.5. I have tried to use...

    Mr. SEA130 pointsBadges:
  • DB2 to Text File Conversion and Transfer

    I have craeted a Text File from my AS400 DB2 table. I want to transfer this file from one iSeries system to another. How to do this??

    gvdsswami20 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