• How to use Timestamp related keywords in DB2 IDDA box

    Hi, I have a Fetch query where I need to get the current timestamp for a particular column. I'm getting -904 error code: due to the usage of 'current timestamp'  keyword in IDDA box accelerator. Is there are any work around for this.

    Rajeshmuthukumar10 pointsBadges:
  • Can you run Entitiy framework with a DB2 iSeries AS/400?

    We're looking to upgrade to Entity framework to work with our DB2 iSeries AS/400. The DB2 iSeries AS/400 is not a new technology. Does anyone know of any problems we should look for in the upgrade or later performance; and whether this configuration will work at all.

    ITKE350,790 pointsBadges:
  • Syspunch with Default value to a column in Load JCL

    Hi, Consider having a unload and load jcl. while loading into the table I like to have a default value for a particular column. Eg. for Column CREATE_TIMESTAMP. I like to have current timestamp to be loaded to the column. current timestamp or timestamp when the load JCL is executing. Can this be...

    Rajeshmuthukumar10 pointsBadges:
  • Data vs. perimeter vs. network security

    A short time ago, author Wes Noonan wrote some tips for SearchWindowsSecurity.com about deperimeterization. He explained how security is always pitted against business needs, and perimeters have become porous because businesses require traffic from SMTP, HTTP or VPNs to pass through the firewall....

    RobynLorusso230 pointsBadges:
  • Database Design Help

    Organizations make business deals with other organizations. When negotiating a specific deal, each organization is represented by one lawyer. The same organization can have deals with many other organizations and it might use different lawyers in each case. Each lawyer has a first and last name,...

    JessRomanowski35 pointsBadges:
  • SQL 2005 Security to access 2 databases on same server via Stored Procedure

    We are tyring to apply best security practices by only granting EXECUTE security to Stored Procedures connected to a Role and make users members of the role. However the SP needs to access data from another DB on the same server and when trying we receive "SELECT permission was denied on the...

    A00001615 pointsBadges:
  • User circumventing security

    We have a rogue user who knows more than she should. She can grant herself and other users the authority to access files that are supposed to be secured. Does anyone know of how we can monitor her activity or go back and review what she has done or anything that we can do. We think she may be using...

    Mouse3330 pointsBadges:
  • Link Query to Report on Access 2010

    In an existing database, I have copied an existing query and an existing report so my new report will be in the same format as existing reports. I changed the criteria on the query so that it is pulling only the information I need. Now I need to link the two so the report will pull just that...

    LindaJenkins5 pointsBadges:
  • conversion problem

    how do you convert DCF files into CSV files for export to Excel Spreadsheet

    ironpony45 pointsBadges:
  • Convert Varchar(max) to XML

    Using SQL SERVER 2008 R2: I have a table with 35 million records, one of the field is of datatype VARCHAR(MAX), it has well formed XML stored. Now we have to convert this column to XML data type. Trying 2 possible ways 1) Creating new column with XML data type and updating that column using...

    SQLdheer5 pointsBadges:
  • DB2 reorgchk current statistics on table all

    With help of below query we are getting output for all tables and indexes  "db2 reorgchk current statistics on table all". But I want only those tables which we can reorg on that tables like *---*,--** etc..... Please provide me SQL query where I can see only that tables name where they require...

    tusharhande85 pointsBadges:
  • Clustered index in SQL Server 2012

    A clustered index is created automatically in SQLserver 2012 while creating a table with primary key. The index is created on the primary key field. My queries which are not using the primary key for search are costing 100% on clustered index scan. Should I create covered index for each and every...

    dhanam115 pointsBadges:
  • Sort process in COBOL/400

    Hi Group,I am trying to understand the significance of sorting in COBOL/400.Sorting is used for arranging records into a specific sequence so that sequential processing can be performed. But, for arranging records in a particular order I can as well create a logical file and process it; Why should...

    mvrkrishna555 pointsBadges:
  • MS Access Functionality Problem

    I have a table with an associated form listing all of our raw materials that we have in house (sometimes multiple lots of materials). I have a table with an associated form defining the components (raw materials) of all of our products I have a “Build” table with which we would use a form to...

    BrianMCSE5 pointsBadges:
  • LDA in COBOL/400.

    Hi Group,How to access LDA in COBOL/400 program?Regards,MVRK

    mvrkrishna555 pointsBadges:
  • Entering -ve values in PF using STRDFU.

    Hi Group,I created a PF and I need to enter -ve values in one of the field by using STRDFU.the field is defined in the following manner: SALES 5P 0 ALIAS(EP_SALES)Thanks & Regards,Rama Krishna

    mvrkrishna555 pointsBadges:
  • DB links

    Please provide a generalized SQL select query to find out which remote database we are connected to using a database link.

    ssk25010 pointsBadges:
  • Open ended SQL queries

    Hi all, I have a requirement to trace the open ended SQL queries running in Oracle Can anyone please help me with a solution. Also please provide me some links where I can find info about Open ended SQL queries. Thanks in advance

    ssk25010 pointsBadges:
  • Access 2007 invalid procedure call or argument (runapp)

    Hi. We have a proprietary Access Database/program that a former employee created for us. We have no knowledge of how to fix it, most of the time it still works just fine.  A user in our office gets the error in the subject when he tries to run it. It worked fine up until a few days ago and I have...

    Longshot95 pointsBadges:
  • Password error

    please help me solve my wifes answering book turbo pascal. I'm not expert to this field but I'm trying to study it myself. i cant solve this one. here it is: Write a program that have a password, and if the password enter 3 times is failed, it will appear 'error'. I would greatly appreciate those...

    haroldbolambao5 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