• 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:
  • Trigger Use

    I have a Sequel Server 2005 database with a Table called Main Call Issue. I want to update the DateTimeModifed field to be the Current System date without changing my original DateTimeAdded field when the record was added to the database. I know a Trigger will work here. Where do I place the...

    Jjc98105 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,185 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:
  • Error copying indexes in DTS package

    I have a DTS package in SQL Server 2000 that copies data from one database to another.  The copy indexes option is checked.  For almost a year this has worked fine until recently where the job is ending successfully but the indexes are not copying over.  At first it was maybe once or twice a...

    Bleeb45 pointsBadges:
  • odbc error while generating crystal reports

    Crystal reports are not getting generated with odbc error. After the upgradation of rational tools from SQL to DB2 version, refreshing crystal reports template is not fetching data and end with ODBC Error. What could be the reason for this? Is any settings needed for this upgradation?

    Createhandle015 pointsBadges:
  • Flat file

    How to copy records from a file to flat file in RPG III

    Gill0075 pointsBadges:
  • What does it mean by related data in a database?

    What does it mean by related data in a database?

    Amitkumar1635 pointsBadges:
  • GET OPID SEGMENT CICS FROM A COBOL/DB2/CICS PROGRAM (RACF)

    Please I need Get the OPID segment CICS  of RACF from a COBOL/CICS  Program.   Thanks JORGE

    RACF5 pointsBadges:
  • AS400 – DB2 concepts

    In AS400, suppose I have 4 files to update and system encounters failure while updating 4th file.....I such scenario will the transactions on first 3 files will rollback.... how can i write a sample program to test this... i want to understand how 'Transaction' is defined in this scenario... Is it...

    Nutangujar895 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