• Count/Sum Question

    Hi I have a field with only 2 values. 0 and -1. I am interested in counting the -1's that occur only if they occur 4 or more times consecutively. Therefore, if the output were 0, 0, -1, -1, 0 the output would be 0. However, if it were 0,0,-1,-1,-1,-1,-1, 0, 0, -1,-1,-1,-1 the sum would be 9. Help...

    Chhmusic15 pointsBadges:
  • Is it possible convert a mainframe COBOL program to read DB2 data on the mainframe and Oracle data on a server?

    I have a mainframe batch COBOL program that reads DB2 data. One of the tables is accessed via a singleton SELECT. The table is being moved to an Oracle database on a Unix server. How do I change the program to be able to access the data in Oracle? Are there different ways to it? I'm assuming there...

    Srichfdic20 pointsBadges:
  • SQL query error: token DATA

    I am new to Db2 on iSeries. I am running some SQL script files using JDBC to create a repository on DB2 for my project. The query is of the form: Create table tbl_name(col1 datatype(size),...... ,coln datatype(size)) DATA CAPTURE NONE; I am getting error on token DATA.. I tried to execute this...

    AS400 - Ask the Expert485 pointsBadges:
  • Enabling php_oci8 on win server 2003, IIS 6, fastcgi

    System setup: Windows 2003; IIS 6 with fastcgi enabled; nts PHP version 5.2.10 (and 5.2.11 just tested); Oracle 9i (full client) Problem: When I add in the extension=php_oci8.dll into my php.ini file, I get a startup error "Unable to load dynamic library 'C:phpextphp_oci8.dll' - The specified...

    Darryn765 pointsBadges:
  • Contest Update: Nominate a member and you could win 1 of 5 Amazon gift cards

    A quick and important update on our Panasonic flatscreen contest and the nominations process -- we will be giving away five (5) $20 Amazon.com gift cards at random to members who nominate someone in the community feedback form here. Thanks!

    ITKE54,755 pointsBadges:
  • coding in c#.net for developing a window

    I need a tab in tools->options window.if we click on that tab it should give 2 text fields one with some default file extensions seperated by semicolon and another text field with valid extensions seperated by semicolon which should be editable i.e user can add/delete an extension to it.for that...

    Devisri20 pointsBadges:
  • AS/400 ASP%

    what is the default ASP% in AS/400 and what is the procedure to define our own.

    now225 pointsBadges:
  • The most-watched IT questions this week: Sept. 22, 2009

    Curious as to what the most popular IT questions and answers are on  ITKE? So were we! So we’ve been watching the watchlists, so to speak, to bring you the top 10 questions, answers and discussions at the top of user watchlists this week. Read them all at our Community Blog.

    Michael Morisy7,943 pointsBadges:
  • DB2 Select on a large number of rows/

    I have to run a DB2 against a number of table for example tableA, tableB and select a number of fields from the table. However, I have to run the selection against 5,000 records that. I want to know if using SQL embedded in a JCL, if I could plug in a file with the records I want to select for...

    Michaelf215 pointsBadges:
  • Extracting data from a DB2 table using IKJEFT01

    I'm trying to extract data from a DB2 table via an SQL query and use IKJEFT01 to create a flat file. However, one of the non-key fields contains characters that are not nulls but non-printable. Whenever IKJEFT01 extracts these characters it changes them to nulls in the flat file. Is there an...

    AlanJ5 pointsBadges:
  • Defining a sort variable (ORDER by) in RPG SQL

    I have a file that I would like to sort on a specific column that a user would choose. I sort the file by an imbedded SQL statement: ORDER by PRDNO. Works fine. If I try and make it a variable (ORDER by :Sort_Seq), the statement is ignored. Is there a way to make the ORDER by a variable in RPG SQL?...

    MurrayInfoSys940 pointsBadges:
  • Display or enable/disable radio button based on response from another radio button

    Hi, I am working on this project where I am dynamically creating a radio button based on the database values. I am using HTML, ASP and COM Components. The portion where I grab the data from the database is working fine. <% For i = 1 to varDriverCount %> <input type="radio" name="Design"...

    Jinisha0 pointsBadges:
  • SQL join two counts on same table

    I have two different SQL statements that each is a count on the same table, but a count of different columns. I'm trying to combine them into a single statement, but am having trouble doing so.  The two statements are:  SELECT photoIDWinner as photoID, count(primaryID) as countWin FROM `rankRaw`...

    Shantheman15 pointsBadges:
  • MarkAndBackupLog step in BizTalk SQL Agent backup job is failing – says db_MarkAll SP is missing!!

    I have activated the first of BizTalk SQL Agent jobs to backup all my BizTalk databases. The second step of this daily backup (MarkAndBackupLog) is failing. The first step (full backup) runs once a day at 4 AM and is succeeding. And the 3rd step of the backup job (clear history) is succeeding. But...

    XandersDad5 pointsBadges:
  • VB script to copy valid data to another file

    I am new to Scripting (Vb).  I need to do the following thru VB script. Is this possible? There are few VB scripts which is currently performing the file transfer function (transferring these files from the network drive to the application). Some times, this text file contain some junk data in...

    JaI825 pointsBadges:
  • How do I set decimal places with VB Access

    I am using Access 2000 database for calibration control of measuring instruments. i.e. micrometers, calipers etc. The precision of the instruments varies and the decimal data fields in the table are set to Auto to minimize the stored values without changing the accuracy. I want to change the number...

    Reject5 pointsBadges:
  • How can I maintain a session in HTTP protocols?

    How can I maintain a session in HTTP Protocols?

    NetworkingATE1,545 pointsBadges:
  • SQL Mismatch in From Statement

    What need to be done if an error message mentions "Mismatch in From Statesmen"? It seems like I have not done any different then what I have done over the last numerous of queries that I have done. I started with an excel spreadsheet. I had to do some concatenation of the some columns. I then...

    CompEng1,185 pointsBadges:
  • XML Publisher in 11i issue

    my concurrent prog ends with a warning(post processing error).but when i download the XML file of the same prog it seems ok,and when I upload it in data defination it genatates a perfect preview. can anybody tell me what is the cause.I want to have an excel output and my template is fine. need...

    Blade0075 pointsBadges:
  • Trouble with Unload statement in VBA

    What am I missing? I have written code with an Unload Userform statement that doesn't seem to wipe out the Userform from memory. For Ex: (Default: CheckBox1.Value = False) MyForm.Show CheckBox1.Value = True Unload MyForm MyForm.Show So, the form is shown to the user, and they mark CheckBox1 so the...

    McNitro255 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