• Substring A Packed Field

    Hello I have a flat record format that I move into an external data structure. Within the external data structure, I have many packed fields. Rather than refer to each of pacekd field by external field name, I would like to be able to substring each packed field out, and then, move the value of...

    Piano520 pointsBadges:
  • Data file not shrinking after deleting data from Outlook 2007

    After deleting emails and data from Outlook 2007 my data file is not shrinking. What else needs to be done and is this something that can be automated across the domain?

    Troubleshooter24755 pointsBadges:
  • What is Referential Integrity in DB2/400?

    What is referential integrity in DB2/400? & What is field reference file in DB2/400?

    40619805 pointsBadges:
  • Enforce only alphabets in a particular field of physical file

    what is the keyword to enforce entry of only alphabets in a particular field of physical file??? for ex: NAME field of EMPLOYEE MASTER.

    Shwesmile20 pointsBadges:
  • Adding column to existing table in a database

    When I add column in existing table. it contains null values in older records. it is possible to assign a value when add column so older records are modified with value

    Shrirama25 pointsBadges:
  • Best practices involving admin rights for user on user system

    We are currently in the middle of figuring out the approach we are going to take in regard to a user having admin rights on their system. Typcially we set up a new user as an administrator on their system when they are logged into the domain. They don't have a local admin account on the system,...

    Kevins740 pointsBadges:
  • Importing large sets of Excel 2000 data to SQL database

    I have large data sets of over 5 million customers in several excel 2000 worksheets. I would like to import the data to a SQL database and preserve all data including notes fields which are huge and contain all types of characters. What is the best method of achieving this?

    ITKE1,142,315 pointsBadges:
  • uploading an excel spreadsheet to the as/400

    I've seen a developer with an Excel spreadsheet on the iseries server, how do I upload an Excel spreadsheet to the iseries and populate it with data so I can then download the finished product to my PC?

    Chuck3105 pointsBadges:
  • Corruption on a Storage Group killed Information Store

    Exchange 2007 SP1, Information Store, Storage Groups and Corruption: Dear Experts, we're running Exchange 2007 SP1. Last week, our service collapsed when one of the storage groups encountered a corruption. We were unable to identify which storage group was at fault, so had to dismount all of them,...

    BGL35 pointsBadges:
  • Query that uses input data from another form

    OK..I need to query a data form that is set to extract data from one table, but I have other fields on the same form that needs to extract data from another table. I have a query that I intend to use to reference the data I need...but my question is what is the syntax to make this happen. Here is...

    DaChosenOne5 pointsBadges:
  • Transfer custom dictionary from one computer to another

    is there a way to transfer the custom dictionary in open office from one computer to another, I've been adding entries one at a time to and old computer and wondering if I would have to do the same for the new computer

    Pia5 pointsBadges:
  • Tool for ETL/SSIS packages testing

    Which is the Best Tools for ETL/SSIS packages testing

    Contactvishal5 pointsBadges:
  • values for nominal data in SPSS

    Why are values for nominal data not listed in numerical order (in SPSS)?

    Nadcjh5 pointsBadges:
  • processing data queues

    I have a program that does the following Calls a program to build entries into a keyed dataqueue. Sample key values are ' 00001' throught ' 00020' Calls a program that reads those entries, and adds new entries to the dataqueue with new key values ('R00001' thru 'R00024'. When it reads the first new...

    Klw50 pointsBadges:
  • Did anyone use DATA structures In CL

    As of V5R4 it is possible to use Data structures in CL similar to RPG. The most useful thing to use is for qualified commands where the qualifie parameter is a File and Libraray. but itl looks to me that it does not work when the parameter is a data structure and the program is CLLE. in CL it works.

    77060 pointsBadges:
  • Master Data Services – Confused by mdm.tblStgMember

    Hi, In Denny's excellent blog on loading data into Master Data Services, he populated the staging tables as follows: INSERT INTO mdm.tblStgMember (ModelName, HierarchyName, EntityName, MemberType_ID, MemberName, MemberCode) VALUES ('Adventure Works', NULL, 'FirstName', 1, '', 1), ('Adventure...

    IanR5 pointsBadges:
  • Databases vs. Data Structures

    I am working for a website company that uses data structures heavily, as opposed to databases. Could someone help me understand the difference between these two? I am recruiting for this company, but am a non-technical person.

    Snc50 pointsBadges:
  • I want to select some rows and show the average of columns of that rows in another row how can i do that in SPSS?

    i want to select some rows and show the ave of colums of that rows in anaother row how can i do that ?

    Za905 pointsBadges:
  • INSERT INTO TABLE1 (SELECT * FROM OTHER DB.TABLE1)

    INSERT INTO TABLE1 (SELECT * FROM OTHER DB.TABEL1)  

    AnandaDebnath280 pointsBadges:
  • Sponsor Post: Join Us for the Identity Access Management Live Expert Chat on 7/20 at 11am ET

    To compete in the new economy, organizations need to provide efficient and secure access to their internal applications and data for external entities, such as business partners, customers, and mobile employees. Join Microsoft's Senior Technical Product Manager, Brjann Brekkan, on July 20 from...

    ITKE1,142,315 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