• The most-watched IT questions this week: Oct. 6, 2009

    Once again, we’ve compiled the 10 most watched questions on ITKE, and found some great discussions on topics ranging from virtualization to disaster recovery to disaster recovery. Go answer a question now and you could win a TV, or check out the rest of the top 10 on the Community Blog: 1. How to...

    Michael Morisy8,323 pointsBadges:
  • Working TRIGGER and TRANSACTIONS QUESTION

    Hello all, My company purchased an operations software (called [strong]darwin[/strong]) that works with SQL 2005 Server. I need to extract some data and save it in my Own Database, which is located in the same SQL Server. On the darwin software there is a screen that updates a field X in a table,...

    LUISCGG5 pointsBadges:
  • Ideal memory for DB2 (V8 fixpak17a) on 64 bit Linux (SLES10SP2) box.

    We are running one instance of DB2 (V8 fixpak17a) on 64 bit Linux (SLES10SP2) box. this box is dedicated to Db2. We have 32G of memory. I would like to know what is the ideal amount of memory to be allocated to DB2 and how much for the OS? Also how much of swap space should we have?

    ITKE352,420 pointsBadges:
  • The IT Blog Top 10: Oct. 1, 2009

    10. Choosing a block size when creating VMFS datastores Eric Siebert provides a guide detailing how to choose a block size for VMFS datastores. 9. Using VRDP to view VirtualBox virtual machines remotely Rick Vanover walks through Sun’s xVM VirtualBox’s ability to tap into VRDP remote viewing....

    Michael Morisy8,323 pointsBadges:
  • DB2 Web Query record count

    Is there a simple way to show a count of the rows printed in DB2 Web Query, such as you can to in Query/400?

    BUEHLER20 pointsBadges:
  • General ODBC Error – Why

    I get an gernal ODBC error when running the below code. It looks like the sqlt is too long, but how can I get it to work as I need the query to be dynamic based on date. sqlt = "SELECT SCHED_TASK_EXEC.TASK_ID, SCHED_TASK_EXEC.TASK_TYPE, SCHED_TASK_EXEC.EXEC_TIME, SCHED_TASK_EXEC.END_TIME,...

    ITKE352,420 pointsBadges:
  • system storage

    Can anybody say if i make one pf with following DDs R RECORD    ENAME           20A    ESAL               5S0    EDOB                L        DATFMT(*MDY)                                     DATSEP('/') NOW I AM...

    Anky10 pointsBadges:
  • Embedded SQL

    In SQL RPGLE program, I declare a cursor using a view.. The view has name Emp_Pat_Dept_Data(EMPdata) the empdata is the AS400 name. In my cursor def which name I should use. Also for the fields referenced do I need to use the renamed field names in the view definition or I can use the field names...

    Nutangujar895 pointsBadges:
  • SQL error

    I've a cursor to fetch date from DB2/400...When date is stored as 0001-01-01, I get error - Year portion of the Date not in correct range. This is the default date my update program stores when user doesnt enter anything for date field. How can I bypass this error while fetching SQL cursor in my...

    Nutangujar895 pointsBadges:
  • Optimizing Query that uses linked tables and bound form w/joins

    I have a bound form whose record source is an Access query.  That Access query involves 3 linked SQL Server tables (one inner join, one left join).  The form takes a while to open. I have run a SQL Profiler and it appears that access is sending two select fields from table without where clauses,...

    Jagoodie60 pointsBadges:
  • HOW TO ADD REPORT IN MENU FOXPRO 2.6

    HI I AM ANKIT, I HAVE MADE A SOFTWARE WITH REPORTS, SCREEN, MENU. BUT I DON'T NO HOW TO ADD REPORTS IN DIRECTLY MENU SO PLEASE TEL ME.

    Netbusinesscorp5 pointsBadges:
  • Access for Windows 5.4

    On one of my PC that uses Access for Windows when I start the Display I also start the printer and it seems to blink the printer screen when starting. So times it just blinks and blinks and bli.nks. I loaded the latest fix, but it only happens on this one machine.

    plaporte55 pointsBadges:
  • Is it possible using Embedded SQL or something else in RPG to directly update and MS SQL DB

    I have a need to push data from the AS/400 to an SQL DB on an SQL 2008 server. I was wondering if there was a way to do this natively within RPG on the AS/400 without purchasing something. Was thinking embedded SQL or stored procedures might be able to accomplish this. Has anyone done this?

    Minidach15 pointsBadges:
  • General question about Database Performance Management Software

    I was just told that Database Performance Management Software apps are always stand-alone applications. That doesn't seem right to me. Are DPMS tools always stand-alone? 

    Margaret Rouse3,040 pointsBadges:
  • DB question(s) that I have never heard a direct answer for

    In designing a database for use where I work, I ran smack-dab into a few old questions I have always had relating to relational databases.  I say "old" questions because I developed them a long time prior.  However, I think the answers are entirely relevant today (obviously, otherwise I wouldn't...

    VirgilReality20 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:
  • Territory code in UDB DB2 database

    A reader wrote in with this question: <i>Can you explain the meaning of the territory code when creating a db2 udb database? Certain documentation say that the territory code determines the way dates are displayed but I've experimented by creating several databases with different territory...

    Leah Rosin575 pointsBadges:
  • Is it possible convert a mainframe COBOL program to read DB2 data on the mainframe and Oracle data on a server?

    I have a mainframe batch COBOL program that reads DB2 data. One of the tables is accessed via a singleton SELECT. The table is being moved to an Oracle database on a Unix server. How do I change the program to be able to access the data in Oracle? Are there different ways to it? I'm assuming there...

    Srichfdic20 pointsBadges:
  • db2 os/390 v8 utility unload template parms

    Hi, We are switching to use the unload utility from the unload program (dsntiaul). I would like to know how to use the template feature to allow multiple volumes to be used in the output. Since we use SMS to manage our storage devices and we want the output on dasd not tape, we normally can code...

    SUZB5 pointsBadges:
  • SQL query error: token DATA

    I am new to Db2 on iSeries. I am running some SQL script files using JDBC to create a repository on DB2 for my project. The query is of the form: Create table tbl_name(col1 datatype(size),...... ,coln datatype(size)) DATA CAPTURE NONE; I am getting error on token DATA.. I tried to execute this...

    AS400 - Ask the Expert485 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