• UNABLE TO WRITE TO A FLAT FILE FROM DS

    Hi Am trying to move a data structure to a flat file.The flat file field name is SASAM. The error is The Result-Field operand SASAM is not valid for the specified operation. The data to be written is CCODE and then the value in HCMPYV. Please find code snippet for ur reference FSASAM IF A E DISK F...

    0 pointsBadges:
  • What are the drawbacks of these two techniques of Change Data Capture?

    Hi can anyone tell me the draw backs of these two techniques of change data capture? 1: Table Differencing 2: Change-Value Selection

    Mahr5 pointsBadges:
  • SQL Server 2008 SISS error row handling

    Struggling with SISS I have data source and data destination With some bad data, I can't figure out how to set up sending the bad row to another destination There are over 50 columns. Sorce is a tab delimited text file Desitnation is SQL Table

    Mambo5 pointsBadges:
  • Moving data from one DB to another DB in SQL Server 2005

    Hi all I got formula to calucalate Row_size of a table Row_Size = Fixed_Data_Size + Variable_Data_Size + Null_Bitmap + 4 Fixed_Data_Size = total byte size of all fixed-length columns Variable_Data_Size = 2 + (Num_Variable_Cols x 2) + Max_Var_Size Num_Variable_Cols = number of variable-length...

    Snivas20 pointsBadges:
  • How to create a Data Area with RPG for storing variables

    How to create a data area using an RPG.I need to create a data area and store some values in it.The value to be stored are also retrieved from the same RPG.(that is from screen variables)

    0 pointsBadges:
  • Program Described Files?

    Whats the use of program described file any example with file dds please?

    6r1,885 pointsBadges:
  • Finding which columns contain data in a table

    I have to establish which columns in a table have data present. Each row has up to 100 columns, and not all of the columns contain data relating to the row. So in Table 1, Col1 Col2 Col3 Col4 Row 1 abc Row 2 abc Row 3 abc Would give a report showing that Table 1 has Columns Col1, Col2, Col4 being...

    TedGiles5 pointsBadges:
  • Data QUEUE – Remote location ….. for program device DDMDEVICE was not found

    When trying to use a remote DATA QUEUE the send and receive data queue commands failed giving : Service with protocol tcp not found. Cannot establish DDM connection with remote system. Operation on DDM data queue DTAQFIFO in TESTLIB failed. Remote location MYAS400 for program device DDMDEVICE was...

    SBCHenry30 pointsBadges:
  • SQL SERVEUR 2005 SISS AND WHERE statement

    I create a SSIS to transfer the date from AS/400 TO SQL Server 2005, and it's work fine. when I go to modify it and I add a where statement to choose only the year 2008, I received the following error code 0x80131937

    Sqlbeg5 pointsBadges:
  • ExcelSource file – metadata validation

    I need some assistance. I am using an excel file to import data to SQL tables. The problem I am running into is having to replace the metadata of the output columns with the metadata of the external columns. I do not want to do this manually everytime. [The metadata of the following output columns...

    Mayre5 pointsBadges:
  • How to enable a trace for SQL Server Analysis Services using T-SQL?

    Hi I want to enable a trace on analysis services Filter only the errors and notifications log them in a table and send a mail. I am right now doing using sql profiler, but i dont want to do this using profiler as i have to log on the server continuously. I need to do this in T-sql like an SP or a...

    GIG240 pointsBadges:
  • Data center analytics question

    What is the future of the data center analytics market? Where can I get market trend data with sizing? Any help here is greatly appreciated. The blueprint attached is quite interesting

    Biligiri5 pointsBadges:
  • Data Area in CL?

    How to get data from Data Area using CL program code?

    6r1,885 pointsBadges:
  • Replicating SAN to DR Site

    We are looking to build a warm DR site across town. How are other companies managing to duplicate their data in a reasonable time to another location? We are looking to copy around 150 GB per day. We don't need up to the minute data, up to the hour or two is acceptable.

    Mpweber20 pointsBadges:
  • How do I prove that a full backup of Fi-Co when restored onto another system is a true and good copy of the source system.

    Hi, during a change freeze and after a full offline backup I am restoring this backup of my current production Fi-Co system onto another server to act as a system reference before making major changes to my live production system. My question is how do I prove to my business colleagues that the...

    Atalanto5 pointsBadges:
  • Converting SQL data to Microsoft Access through coding in VB.NET

    I have tables in SQL and i want to port them to MS access through coding in VB.NET

    Kiti15 pointsBadges:
  • What is the difference between Hitachi ShadowImage, Hitachi TrueCopy and Universal Replicator?

    What is the difference between Hitachi Shadow image, Hitachi True copy and Universal Replicator? What are the best scenarios where each of them can be implemented?

    SearchStorageATE215 pointsBadges:
  • SQL Queries

    pls any one help me I Need to disply in o/p only alphabets but not any numbers or integers for this i/p as follows i/p o/p ----- ---------- 1.2NE NE 1.1NN NN 1.3.1NE NE 1.1CE CE 1.2.2NN NN 1.6.2NN NN 1.3CE CE 1.3CE CE 1.1 --- 2 ---- 11 -- THANKS IN ADVANCE SURENDRA

    Ecsbc35 pointsBadges:
  • Macs and SPSS 17

    Which mac would be best to use for statistical analysis using SPSS? I know that most PCs make this easy with WIndow and MS Access as db, but I have a house and office filled with Macs - only other option is to add a PC. Thanks!

    StatsMan5 pointsBadges:
  • Write Lotus Notes records from a Lotus Notes database to a DataMart in Oracle

    I'm new to LEI and I need to write Lotus Notes records from a Lotus Notes database to a DataMart in Oracle. Does anyone know where I should start on this, or if possible can anyone provide a code snippet? Thank you in advance.

    Domino Ask The Experts435 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