• Free IT Book: The Accidental Administrator: Cisco ASA Security Appliance

    This week's free IT book comes with a bonus interview with the author, Don Crawley! Check out what he has to say about the book, the process, and the joys of being an IT-type personality. Then answer one of the questions below and post the link to your answer in the discussion section for your...

    MelanieYarbrough6,345 pointsBadges:
  • Top N query using DB2

    I need to perform a Select top N * from as400table query against an AS/400 using DB2. Any thoughts?

    ITKE342,790 pointsBadges:
  • How do you do LIMIT in DB2 for iSeries?

    We currently have a table of more than 50,000 records and we're trying to return records of 0 to 10,000 / records of 10,000 to 20,000. We already know that in SQL, if you write "LIMIT 0,10000" at the end of the query, it will bring you that record. How can you do it in DB2 for iSeries? Thanks!

    ITKE342,790 pointsBadges:
  • How do I update rows in DB2?

    How do I update rows in DB2. When I used SQL, I was able to go forward with this: update top (100) table1 set field1 = 1 This doesn't work in DB2. Any suggestions on what I should do instead?

    ITKE342,790 pointsBadges:
  • 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.

    ITKE342,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:
  • Inserting multiple rows in Oracle 10g

    I need to insert multiple rows of data into multiple tables from one temporary table. I need to put some of the columns into one, some into another, and the remainder into another table. I realize I will need to create INSERT statements for each table insert. Is there an easy way to select specific...

    Ora mer20 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...

    mvrkrishna530 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

    mvrkrishna530 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