Questions & Answers

  • iSeries: Text fields from different records in same file

    We have some data (in a file of course) on iSeries using DB2. Here's the file structure:Item Textline Text 12755 1 this item 12755 2 is no longer 12755 3 for sale abc123 1 please use abc123 2 another code xyz987 1 obsoleteThis is the result that we're trying to get: Item Text 12755 this item is no...

    ITKE344,900 pointsBadges:
  • What are the best ways to input data for consistency?

    As business intelligence and analytics adoption expands within organizations, there's a natural push from business users to add more types of data from disparate sources -- often external ones -- to BI systems. That raises questions about the validity, consistency and overall quality of the data...

    Chris Leonard4,300 pointsBadges:
  • Problems in iSeries with Entity Framework

    Working in AS/400 withDB2Connect with Entity Framework, trying to create a EDMX file in iSeries. I can see that records have been produced but cannot save them. I get this error message: ERROR [55019] [IBM][AS] SQL7008N REXX variable \"INVENTORY \" contains inconsistent data. My initial research...

    ITKE344,900 pointsBadges:
  • Parameter issues in VB.NET for AS/400

    I am having problems getting parameters to work within a VB.NET query written to AS/400. Any time I include a parameter in my query (ex. @MyParm) it doesn't work. I get the following error: SQL0206: Column @MyParm not in specified tables Here's my code: Dim da As New OleDbDataAdapter Dim dt As New...

    ITKE344,900 pointsBadges:
  • SAS credit card deliquency project

    Hi, I'm an entrprenure and just want to start some project on SAS. I have got a client and just want to know about that. Can you guys help me with a real time SAS project or can you guide me that where to find that project?

    rkumar715 pointsBadges:
  • Career / Job Opportunities?

    I am looking for a new career and computer forensics and security seem to be a field with a lot of promise. Can you suggest how some one may begin a new career in this arena?

    foxjohnsix5 pointsBadges:
  • SSD desktop config

    I just purchased 2 SSD`s for my new desktop build.I am thinking about putting the OS on the smaller drive.Is this the best possible set up? Thank you in advance!SAMSUNG 840 Pro Series MZ-7PD256BW 2.5" 256GB SATA III MLC Internal Solid State Drive (SSD)Kingston HyperX 3K SH103S3/120G 2.5" 120GB SATA...

    rinabinet5 pointsBadges:
  • What’s wrong with my following code for connection to a DB2 database?

    I'm trying to connect to a DB2 database with PHP. I have a code but it's not really doing anything for me. It's not returning an error message but just breaks JavaScript later in the page. Here's the code:include(TEMPLATEPATH.'/inc/library/adodb_lite/adodb.inc.php'); $DBName = 'DBNAME'; $Host =...

    ITKE344,900 pointsBadges:
  • Strange compute function results in AS/400 while using Cobol

    Can someone help me solve this problem using the COMPUTE function in AS/400. 01 WSAA-AMOUNT-A PIC S9(15)V9(02) COMP-3. 01 WSAA-AMOUNT-B-01 PIC S9(16)V9(02) VALUE 0. 01 WSAA-AMOUNT-B-02 PIC S9(13)V9(05) VALUE 0. 01 WSAA-AMOUNT-C PIC S9(16)V9(02) VALUE 0. 01 WSAA-RESULT PIC S9(15)V9(02) VALUE 0. MOVE...

    ITKE344,900 pointsBadges:
  • Establishing a connection from an IBM DB2 database

    I've been trying to establish a connection with an IBM DB2 database (from which I can extract data). Here are some of the details I have:Server NameData LibraryUsername/PasswordI've used both Microsoft Excel and SQL Server 2008 but neither way is working. Using Excel, this is what I tried: I have...

    ITKE344,900 pointsBadges:
  • Base compiler program in SQLRPGLE

    I'm writing a compiler program in SQLRPGLE that will be used in a lot of programs that will run throughout my system. Obviously, I want to get it right so that I don't have a bunch of problems down the road, and right now it doesn't work.  Could you take a look at what I'm trying to do and suggest...

    ITKE344,900 pointsBadges:
  • How to see a timeout in connect/send in AS/400?

    My team and I recently created a socket client in RPG that calls a Java server socket. However, the problem that we're running into is that connect()/sent() operations blocks and we have a requirement that if the connect/send couldn't be done in a matter of a second per say, we have to just log it...

    ITKE344,900 pointsBadges:
  • Is COUNT a valid expression in SQL DB2 in iSeries?

    Can I use COUNT in SQL DB2 in iSeries for row partitions? I've tried to run the following query: select COUNT(1) over (partition by COL1, COL2) from MyTable and received the following error message: [Message SQL0401] Token ( is not a valid token. A partial list of valid tokens is , FROM INTO. How...

    ITKE344,900 pointsBadges:
  • manage audio shows no audio device found in my windows xp 2002 sp2

    Dear sir, my audio manager in control panel shows no audio device found. So sound is not creating on my system. Is my HD audio driver corrupted or missed. So please help me.

    subrat96325 pointsBadges:
  • reading ldif file

    can i have any tools to read the ldif file

    areef62325 pointsBadges:
  • Soft menu configuration in AS/400

    Hi, I would like to know the approach to configure menu to different user profile based on their authority. For eg:- user A should see only 1-10 menus and User B should see only first 5 menus. Previously this was done with simple display file and message files. Now this has to be changed to a soft...

    RamvishakRamesh2,505 pointsBadges:
  • Retrieve browser icon

    The entries in the service book of my BlackBerry model 8520 was deleted by mistake due to which i lost the browser icon. How do I retrieve it?

    seshadrig5 pointsBadges:
  • IMPORT OR EXCEL DATA INTO ORACLE FORMS 6I

    Hi all, i have to import excel data of two column into oralce forms 6 i on button pressed trigger.can any one help me in this regard with source code.thanks a lot in advance

    ZOMGPS5 pointsBadges:
  • tabs in kronos

    missing tabs in kronos

    Pwmartin15 pointsBadges:
  • Condition error EDD168

    How to resolve the EDD168 condition error in SAP?

    ramdass5 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