• Find the DB2 Contoken

    I have the load modules, can I look at them and find the DB2 CONTOKEN to match the package contoken?

    BhleftD10 pointsBadges:
  • DB2 Spufi output formatted

    How do I get 2 lines of user specified headings using db2 SPUFI: SELECT A AS "LINE1 HDG" "LINE2 HDG" FROM TABLE doesn't work.

    Dhanson20 pointsBadges:
  • DB2 Select on a large number of rows/

    I have to run a DB2 against a number of table for example tableA, tableB and select a number of fields from the table. However, I have to run the selection against 5,000 records that. I want to know if using SQL embedded in a JCL, if I could plug in a file with the records I want to select for...

    Michaelf215 pointsBadges:
  • Extracting data from a DB2 table using IKJEFT01

    I'm trying to extract data from a DB2 table via an SQL query and use IKJEFT01 to create a flat file. However, one of the non-key fields contains characters that are not nulls but non-printable. Whenever IKJEFT01 extracts these characters it changes them to nulls in the flat file. Is there an...

    AlanJ5 pointsBadges:
  • SQL join two counts on same table

    I have two different SQL statements that each is a count on the same table, but a count of different columns. I'm trying to combine them into a single statement, but am having trouble doing so.  The two statements are:  SELECT photoIDWinner as photoID, count(primaryID) as countWin FROM `rankRaw`...

    Shantheman15 pointsBadges:
  • CPYTOIMPF data corruption

    CPYTOIMPF on V5R4 with latest PTF's adds invalid data to the created CSV file for some blank fields in the PF. Is this a Bug?

    JMShmc5 pointsBadges:
  • How do I set decimal places with VB Access

    I am using Access 2000 database for calibration control of measuring instruments. i.e. micrometers, calipers etc. The precision of the instruments varies and the decimal data fields in the table are set to Auto to minimize the stored values without changing the accuracy. I want to change the number...

    Reject5 pointsBadges:
  • mainframe db2 – get current month and year

    Please advise. My DB2 statement does not work. gl_date is a date field, format is 'yyyy-mm-dd'. select * from db2 table where year(gl_date) = year(current date) and month(gl_date) = month(current date);

    Rulala5 pointsBadges:
  • dbcc checkdb error; object id 0

    Hi, We have been ask by one of our customer to restore a database from SQL Server 2000 and SQL Server 2005. The restore completed however when we run a integrity check on the database errors occurred. We than ran an integrity check with repair allow data loss option, as the customer is happy to...

    Db23290 pointsBadges:
  • Are your administrative and technical security protocols run separately or together?

    Do you have the same team managing your administrative security (user permissions, access controls) and your technical security (antivirus, firewalls), or are they managed separately? What factors influenced your organization's decision?

    JennyMack4,280 pointsBadges:
  • The most-watched IT questions this week: Sept. 15, 2009

    As part of a new feature on the IT Knowledge Exchange Community Blog, we're highlighting the top 10 most-watched questions. Here are the top 5: Virtualization vs. ConsolidationTracing a computer to an IP addressConnect remote Oracle 11g server in VB 6.0How to utlize multiple static IP's when ISP...

    Michael Morisy8,323 pointsBadges:
  • AS400 – DB2 file names

    Given a view name, how will i find its physical file name... e.g. my view name is EMP_TMP_TPL_HDR Thanks, NG

    Nutangujar895 pointsBadges:
  • Oracle ODBC Windows Server 2003 scheduling issue

    I have a win 2k3 server running an MS Access odbc application that automatically links to an oracle database using the Oracle Instant client. The problem is that it runs fine when run from the Servers console as a local machine user, but fails when run from the windows at.exe scheduler. It seems...

    Ttstudio45 pointsBadges:
  • Controlling tempdb Growth

    I have a user running a SAS job that kicks tempdb from 8.5M to 6.6Gig in less than ten minutes. tempdb is on the default C: partition, which is only 16G (I have no control over that ridiculous size)! I’m new at this so I’m thinking my only option is to MOVE tempdb because of the space...

    VelameLaCosa110 pointsBadges:
  • As400 – XML

    Can i pass value from DB2 400 to XML.. how to do this?

    Nutangujar895 pointsBadges:
  • PeopleSoft Index Peformance

    Should a PeopleSoft table that has only 1 field in it have that field also defined as a key?

    LB28095 pointsBadges:
  • IDelete QPFRDATA

    Hi, I just want to ask if it is possible to delete the PF (Physical File) inside my performance data library without causing any problem on my AS400 system. I found out that its file is so big.  

    c007285 pointsBadges:
  • DB2

    i have display file which inputs a varibale say Var1.... This is updated in a PF. My problem is program is not updating this varibale in this file. it updates all other varibales...i checked the library list and evrythng is in place... in PF, the field name is Var1. i use the same name for DSPF -...

    Nutangujar895 pointsBadges:
  • Working with SQL: Extracting Data or Text within a Query, adding new column for extracted data

    I have created a passthrough query in access to draw information from an AS400 system. I have also created some tables in excel and copied and pasted them into access to link them to the AS 400 query via access. So as of now I have three files in one access passthrough query. The one file is "...

    CompEng1,240 pointsBadges:
  • Community Update: The IT Blog Top 10 for Sept. 10, 2009

    As part of a new feature on the Community Blog, each week we'll be doing a run down of the 10 most popular blog posts over the previous week, in case you were wondering what your peers were reading or a hot topic somehow missed your radar. Still think we missed something? Send me an e-mail at...

    Michael Morisy8,323 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