• Performance Optimisations

    I need to optimize the DB for my Company web site expecially I need to be sure that I have all the right views. There is tool that analize the SQL request and propose to create the needed views? Thanks.

    Fsoster0 pointsBadges:
  • SET verb in COBOL

    Hi The SET verb in COBOL set the value of a particular variable to a specified value. Now say I decalred a variable as 05 WS-SWITCH PIC X(01). 88 VALID-VALUES VALUE 'A', 'B', 'C'. 88 NOT-VALID-VALUES VALUE 'D', 'E', 'F'. If I want to set the value of WS-SWITCH as 'A', we can do as SET VALID-VALUES...

    Pgsdeb20 pointsBadges:
  • iSeries any beyond

    I'll start by introducing myself and my background and then hopefully explain what information i'm looking for. I'm a COBOL developer for an insurance company based here in Ireland. I'd like to think of myself as been proficient at programming and at navigating my way around the AS/400. I have...

    ITnavan0 pointsBadges:
  • How to solve lock problem in Oracle 9i on Linux

    Hi DBAs I have foundPersistent Lock in my database Suggest me how to solve this error.

    Murtujakhokhar0 pointsBadges:
  • Cannot connect to Database Oracle Error -1033.

    Hello, I have a Problem with my HP B132L-Workstation, running HP-UX 10.20 and Oracle 7.x. An application, which is based on the Oracle database won't start any more with the Error Message: Cannot connect to Database Oracle Error -1033. My first guess was, that the Harddisk is defective, or the...

    Pine140 pointsBadges:
  • Data Integration

    We are in the beginning stages of integrating data between a PC based inventory system and the iSeries. Specifically we will be downloading and uploading data between the two systems automatically. We have had success using ODBC. We also need to be able to call an RPG program from the PC based...

    Christina0 pointsBadges:
  • Lotus Notes and DB2 support, or lack there of.

    We are a longtime Notes Domino shop with several databases in NTF format. We did a Beta of ND7 and DB2, on a single server. Now we are serious about developing a Bug and Enhancement tracking system for our own software application. On 2 servers; one for ND7 and one for DB2. Problem; there is...

    Sehaugen0 pointsBadges:
  • Regarding Oracle connectivity issues

    I have Oracle 7i and 9i installed on my PC under C:/ORANT and C:/ORA9 respectively. When i try to connect to Oracle from a front end application (Visual Basic v6)that takes as input the Database domain name and Database schema name as input and tries to establish a connection to Oracle using the...

    Vabene0 pointsBadges:
  • Migration from OS/390 to Z/OS V1.6 with CSP

    We are migrating from OS/390 v2.10 to Z/OS V1.6 as V1.4 is no longer available.We still keep some old application development environment based on CSP/AD and CSP/AE. Is there any issue other than adopting the new LE library that we need to be aware of?

    Terk1f0 pointsBadges:
  • Using Query returned values in Oracle Graphics 6i

    Hi all, I wrote a query in Oracle Graphics Builder (6i)(Bar Graph). The query will return diff. categories(so multiple bars) wherein each category will contain atleast one subcategory(Maximum three). So, each bar will contain either one or all the three sub-categories. My requierement is to set the...

    Mphani0 pointsBadges:
  • VPn solution required for remote IP telephony

    We would like to have remote ip telephony connectivity for our office so that it will be helpful for our remote users and our Royal customers to have ip soft phone which will be connected to our network through VPN tunnel to our IP PABX and dial out locally. We are having ADSL modem connectivity...

    Gobinatty0 pointsBadges:
  • CUM PTF V5R3

    I am preparing to install the latest cum. I have red through the PSP and noticed that some PTF's need to be installed before this cum; however, I was unable to determine which ones were required. We are running a model 520. Can anyone supply me with the numbers for those required PTF's before the...

    sangren0 pointsBadges:
  • DB2 Joins

    Can someone explain the order this join specification will be performed in? RSINDIP LEFT OUTER JOIN RSINDPP ON RSINDIP.INICID=RSINDPP.IPICID LEFT OUTER JOIN MKEMLAP ON RSINDIP.INCID=MKEMLAP.ELEMIC LEFT OUTER JOIN MKIPRMP ON RSINDIP.INICID=MKIPRMP.IKICID LEFT OUTER JOIN RSTHSTP ON...

    Intravler0 pointsBadges:
  • Indexing on Large table

    Hi, Is indexing on 5 keys of a table containing 100 fields more slower than indexing on same 5 keys of a table containing 150 fields. Both the tables (one containing 150 fields and other containing 100 fields) are similar except the 50 attributes which are redundant. Suppose there are 2 attributes...

    Abhigreen10 pointsBadges:
  • Delete maximum records in a table

    Hi! I need to Delete maximum records in a table that has 2 columns, such as Ord No. & Part No. Each Part No. can have many Ord Nos. I need to identify the Maximum Ord No per part No & delete the record from the table. Help would be much appreciated! Sarj

    2908610 pointsBadges:
  • SQL Server 2005 adoption

    My name is Nick Bellistri and I am the assistant site editor for SearchSQLServer.com. I am interested in your thoughts on SQL Server 2005 adoption. Based on your knowledge of SQL Server 2005, what hurdles do you foresee in using the new DBMS? Do you think Management Studio will be more difficult to...

    Nbellistri0 pointsBadges:
  • Stop bit problem: USB to Serial Converter attached to motion controller, unable to set for 7-E-2

    I have three different USB to Serial converters, one of them an isolated converter from B&B. One brand of motion controller I work on uses EVEN parity / 7 data bits / 2 stop bits as its default. I find that none of my converters will work on the controller in this configuration. If I borrow a PC...

    Kfink040 pointsBadges:
  • Group Policy Management

    Has anyone looked into Group Policy Management products (outisde of the functionality provided by Microsoft's Active Directory)? I'm trying to choose a product, and wanted to compare based on what current users thought (rather than what the sales departments tell me). The products I've been able to...

    TechSpaght0 pointsBadges:
  • SPAM

    I am running Exchange 2003 and Win2k3 servers. we get a ton of spam, and I want to stop it. What in your opinion are the best SPAM softwares and why? (such as strong points and weak points) let's hear it....

    TheVyrys0 pointsBadges:
  • AOL Spammer IP Identification

    Concerning the ever increasing amount of received spam, to battle this I have a program with which I can extract the IP address from the sender for reporting purposes, however, I have been receiving an increasing amount from AOL proxy server for which I cannot aquire the senders IP address. Is...

    Eyecatcher550 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