• Triggers

    Does the AS/400 have a cross-reference file or files that give the same kind of information about triggers as QADBFDEP and QADBFCST do for dependent files and constraints? If so, what is/are they called? Thanks

    Xixones0 pointsBadges:
  • Microsoft: Active Directory Migration Tool (ADMT)

    Hi, I want to migrate a couple of users, computers and groups from an Windows NT 4.0 Domain to Active Directory (Windows 2003 NATIVE MODE Domain). The migration is not for the entire NT Domain, is only a group of users and computers from this one. I had used ADMT on a single forest to reorganize...

    Schnell0 pointsBadges:
  • How to purge records from the database?

    I am a newbie to database programming and have been given this project where data older than 7 days need to be removed from multiple tables that the application uses. I am thinking about creating a stored procedure to do that and schedule a job that will run this stored procedure everyday. Not sure...

    Jinisha0 pointsBadges:
  • How to avoid SQL7008 error from DB2 on iSeries?

    We are deploying a J2EE application on a Websphere 5.2 Application Server. This application accesses a DB2 database on an iSeries server which is not supporting transactions. We have already removed all transactions from the XML configuration files. We cannot find a way to configure the datasource...

    Cardura0 pointsBadges:
  • Stored Procedure Error

    This is mu stored Procedure: CREATE PROCEDURE ADMINISTRATOR.DIMS_SP_PerformSearch ( vuserId integer, vsearchText varchar(500) , vfromID integer, voption integer ) ------------------------------------------------------------------------ -- SQL Stored Procedure...

    Jsbaig0 pointsBadges:
  • How do I check for changes in a database on insert / update?

    Hi there, I have an interesting problem. I need to write a program that checks to see if data has been inserted or updated into a Microsoft access database or sql server database. The program needs to be compatible with both types of database, so using triggers is not possible as it wont work in...

    Scooby0 pointsBadges:
  • WALLDATA RUMBA File Transfer Function

    After upgrading from NT to XP or Win2000, the File Transfer function no longer works. Arpeggio is fine but the File Transfer application error is:[Wall Data][Rumba Data Access]No data source specified; dialog prohibited. SQLDriverConnect.... Maybe there are registry entries missing?...

    RPGGuru0 pointsBadges:
  • Installing Siebel 7.7 on a stand alone machine with DB2

    is any one trying to do that ? i have heard that it's a big hasle. i will be trying to do that shortly in the next couple of days or next week. can any one tell me about the basic steps and permissions or user groups i need to set up ? i am working on Windows XP Professional. Kaushal

    Zagade0 pointsBadges:
  • DB2 SQL delete to purge Header/Detail records

    I have a Header file with Detail records that belong to it. I need to copy the detail data off to a backup file, delete the detail records where the Header record entered date is greater than xx days from the current date, copy the header data off to a backup file and finally delete the header...

    Bam19570 pointsBadges:
  • Cobol, DB2, and DDS

    Am finally starting to move S/36 apps to native OS400! How do you use DDS to define repeating data, for example, a table in a file using the OCCURS clause ... 05 YTD-SALES OCCURS 12 TIMES PIC S9(8)V99 05 YTD-BUDGETS OCCURS 12 TIMES ... I suppose you could just define an area in DDS of X(120) and...

    Crooksb0 pointsBadges:
  • Excel Help

    What I have now is a simple excel spreadsheet to input numbers and info. What I want to do with it is make it a template and have one cell in the top left corner to add a new number in order each time a new user opens it. For example in the cell would be number 123 and the next time when someone...

    Ctg02315 pointsBadges:
  • Db2 to Oracle porting

    I am in the process of planning to port a running DB2 instance on an IBM Mainframe to Oracle 9i running on Unix. Has anyone done does this before ? If yes, what should I be looking out for ? Any particular advice ? Thanks and Regards, Debu

    Dpd08090 pointsBadges:
  • Installing Oracle 9i Standard Edition on Windows Server 2003 with Xeon CPU: Why does Java Virtual Machine fail?

    We are replacing an old NT 4.0 server with a new Windows Server 2003, the new hardware (a Compaq ProLiant) equipped with Intel Xeon CPU. The old server was running a couple of database instances in Oracle 8i Standard Edition, which we want/need to replace with the 9i version. The installation files...

    Onilke95 pointsBadges:
  • SQL Server ODBC Configuration

    I've got an NT web server in our DMZ that can't connect to an internal SQL Server 7 db on W2k box. Internally we have 2 domains. ODBC returns access denied/can't find server. When I put the websrv inside our net, ODBC works fine. Other servers in DMZ can connect to db. What is going on?

    Rmartinez780 pointsBadges:
  • Mainframe security / Racf

    My first time on ITKE , so please forgive, but why do I not see any RACF/Top Secret/ACF2 related issues? It should be under security, or not ? Thanks Pieter

    Swannie0 pointsBadges:
  • Starting isql*plus

    Hi every one! I know that to start isql*plus in a browser, you are supposed to type something like: http://localhost:<port_number>/isqlplus Problem is, how do you determine the localhost and port number? Second, how can i use Enterprise manager to create reports about my tables in the Oracle...

    Wanaug5 pointsBadges:
  • MIgrating SQL Server 2000 to Active Directory

    When migrating a Server that hosts a SQL Server 2000 Instance from an NT Domain to an Active Directory Domain, What, if anything, needs to be done withing SQL Server for everything to work properly???? Since migrating the host Server to AD, my NT Authenticated SQL Server Logins are not working...

    Jpotucek0 pointsBadges:
  • How to alter more than one existing columns in SQL 2000 Server?

    I m working in SQL Server(2000) Enterprise Edition.When I m using "Alter Table <tablename> Alter Column <column name> (column definition)" for only 1 column then its working (using Query Analyzer). However when I m trying to alter more than 1 column, Query Analyzer is giving error...

    Bakash0 pointsBadges:
  • Alternate way to stop Oracle Services on Win 2K Server

    Our database server is a Machine running Windows 2K Server. We make our backups stopping the Oracle Service and then copying the files to other location (and then to tape), but in order to do this, the user loged in on the server must be an administrator, and this is a problem, because the backup...

    carlosdl84,310 pointsBadges:
  • Alternate way to stop Oracle Services on Win 2K Server-2

    Our database server is a Machine running Windows 2K Server. We make our backups stopping the Oracle Service and then copying the files to other location (and then to tape), but in order to do this, the user loged in on the server must be an administrator, and this is a problem, because the backup...

    carlosdl84,310 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.

Thanks! We'll email you when relevant content is added and updated.

Following