Questions & Answers

  • xml-into problem

    I want to process an xml file from the IFS in an RPG program, but always get "The XML parser detected error code 302." Nothing I do seems to fix the problem. I checked the XML-file with WRKLNK, it is ccsid 1208 (utf-8) and the first character is 3C (<). Job ccsid is 65535. Iseries release...

    BestUM15 pointsBadges:
  • SQL – Select record using MAX over date in 3 fields mm dd yy

    I have a file that contains PART#, Price, EFFMM, EFFDD, EFFYY. There can be multiple records for a PART#. I want to use SQL to join to this file by PART# and select the PRICE for the record that has the most current date. Simple in RPG, but I would like to do with SQL.

    CharlieBrowne41,370 pointsBadges:
  • Shared Tape Drive

    How Can we check what other lpars are using shared tape drive. i.e. TAP01 is share tape drive on LPAR01 and I need to know what other lpars are using the same tape drive?Currently We are using 3592

    MayurRastogi390 pointsBadges:
  • Open a file

    Which program opens *.mes files in Win XP? This a saved message file.

    bbbbbafel10 pointsBadges:
  • How to get rid of blank areas

    I have a database that contains path diagnoses (rows) and stains (columns) used to determine diagnoses. Therefore for any single entry there may be multiple empty columns. When I make a pivot table I want to be able to show only columns with data in them.

    mensamedic5 pointsBadges:
  • Excel.exe process is getting struck in task manager and it’s not closing even the session is end

    Hi, My code is invoking Excel process to generate the report and that is killing once the process is completed. But sometime, couple of Excel.exe process is getting struck even the session is ended. Which is causing NFS memory full. Please advise me of what the the root cause to this issue is. By...

    FIRSTSCHOOL5 pointsBadges:
  • Recipient list

    Not all my recipients from my Excel document are in my mail merged document

    LynnMT5 pointsBadges:
  • DosCreateMutexSem privilege escalation

    I am looking for an explanation of how a privilege escalation hack would be able to be inserted with a call to doscreatemutexsem function from a windows service that is running under the local system account.  I was unable to find anything on Google and not being a security expert I just don't see...

    CarlCioffi345 pointsBadges:
  • Implementation

    Looking at migrating a municipality from Windows to Linux on servers and mainframe. Looking for cost effective models eg LAMP on web servers, CentOS or Fedora on mainframe with Oracle or straight to Oracle Linux and Ubuntu on desktop? Need some ideas.

    LinuxDummy5 pointsBadges:
  • HP T-TR status cliente error

    Is anything worst than to deal with HP printers?

    snavarro15 pointsBadges:
  • Lines of code in c-spec

    How can I count the number of lines of code in c-spec with eliminating d and f-spec?

    rpgle45 pointsBadges:
  • Creating a SQL script for determining if a sequence exists

    I'm looking to create a SQL script to see if a sequence exists in my SQL Server 2012 database. I understand the concept of stored procedures but not with sequence.

    ITKE342,235 pointsBadges:
  • Adding appointment to shared calendar opens an email form to calendar owner

    I have a business client uses Microsoft Hosted Exchange. One of the 15 users is having difficulty creating appointments in shared calendars. On one PC, she uses Office 2007 with Outlook 2013, and on another, Office 2013. In the shared calendars, when this user tries to add an appointment to any...

    Fritzman5 pointsBadges:
  • Query selected data convert into XML file in AS/400

    I have 5 PF. Now I want to select data from my PF and selected data need to convert into XML. Please give me guidelines, how do I do a step-by-step?

    madhuchowdary350 pointsBadges:
  • Meaning of loop in flowchart

    What do you understand by loop in flowchart?

    sam8310 pointsBadges:
  • Return a tuple of datetime objects in Python

    I want to write a function that returns a tuple of (start,end) where start is the Monday at 00:00:00:000000 and end is Sunday at 23:59:59:999999. start and end are datetime objects. No other information is given about day, month or year. i tried this functiondef week_start_end(date):start=...

    michaels325 pointsBadges:
  • Oracle And Microsoft Certified Solutions Expert

    HI ,I'm currently learning Oracle. Is it wise to Take up MCSE :Data platform as well to get a fill for both platforms ?

    biggy1234565 pointsBadges:
  • Should I use SQL Server 2008 R2 or Postgre 9?

    I'm rewriting an application for my company which requires a database. I will be updating the database using SQL Server 2008 R2. Now, here's my big question: Should I use PostgreSQL 9?Note: I won't be doing any conversions so that's not a problem.

    ITKE342,235 pointsBadges:
  • Counts by time and date with

    I am trying to count logins by hour, by month, etc., in SQL Server 2008. To do this, I believe I need to create two PIVOTs or an UNPIVOT and then PIVOT? However, I can't seem to make it work. SELECT loginid ,DATEPART(MONTH,logtime) Month , DATEPART(HOUR, logtime) Hour FROM somelog (nolock) ) temp...

    ITKE342,235 pointsBadges:
  • SQL Server 2012 Express has slowed down dramatically

    I just recently moved my .NET Development over from a Core2Duo to a new Core i7-3820 machine. No changes were made to the project code and both run on SQL Server 2012 Express.For the past week, I've seen a dramatic slowdown with INSERT INTO commands. Can someone tell me why this is happening?...

    ITKE342,235 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