Informatica MAP creation to RESTART
I have to develop maps which execute extracting and loading data. If, because of any reasons MAP failed with any errors have to fix and restart the same MAP, this time it has to start processing data where it got failed. Please let me know how could I develop map satisfying in both situations.
Answer Question
| July 24, 2008 11:41 AM
Data mining/analysis, Database programming, Informatica
I have to develop maps which execute extracting and loading data. If, because of any reasons MAP failed with any errors have to fix and restart the same MAP, this time it has to start processing data where it got failed. Please let me know how could I develop map satisfying in both situations.
Answer Question
| July 24, 2008 11:41 AM
Data mining/analysis, Database programming, Informatica
Gentran 850
We are using Gentran into SAP 4.6. Where do you map the SHIPTO segment of an inbound 850 to? Is a Text Element the only way?
Answer Question
| December 14, 2010 11:40 AM
850nm, EDI, Gentran, SAP 4.6, SHIPTO
We are using Gentran into SAP 4.6. Where do you map the SHIPTO segment of an inbound 850 to? Is a Text Element the only way?
Answer Question
| December 14, 2010 11:40 AM
850nm, EDI, Gentran, SAP 4.6, SHIPTO
Open Source ERP : Immediate Help would be highly appreciated
Could anybody give me insights about Open Source ERP, benefits over specific modules other than the cost implications/ Also, are there any risks involved? Does there exist any framework for the implementation process?
Answer Question
| July 25, 2008 12:38 PM
ERP, Open Source ERP, Software
Could anybody give me insights about Open Source ERP, benefits over specific modules other than the cost implications/ Also, are there any risks involved? Does there exist any framework for the implementation process?
Answer Question
| July 25, 2008 12:38 PM
ERP, Open Source ERP, Software
BDC and Batch Input
What is the actual difference between BDC and Batch input in ABAP? Is there any difference at all? -Gururpasad R
Answer Question
| May 17, 2011 4:31 AM
ABAP, Batch Data Communication, BDC
What is the actual difference between BDC and Batch input in ABAP? Is there any difference at all? -Gururpasad R
Answer Question
| May 17, 2011 4:31 AM
ABAP, Batch Data Communication, BDC
Crystal Reports 6.0 and Windows Vista
Has anyone been successful at running Crystal Reports 6.0 under Vista? I get error File could not be opened: “filename”, at file location: “filename” OK to close followed by error – RptName – Run-time error 20535: Unable to connect: incorrect session parameters or just the 20535 incorrect session parameters. I had these issues trying to [...]
Answer Question
| July 23, 2008 8:40 PM
Crystal Reports, Crystal Reports 6.0, Error 20535, Microsoft Access, Windows Vista
Has anyone been successful at running Crystal Reports 6.0 under Vista? I get error File could not be opened: “filename”, at file location: “filename” OK to close followed by error – RptName – Run-time error 20535: Unable to connect: incorrect session parameters or just the 20535 incorrect session parameters. I had these issues trying to [...]
Answer Question
| July 23, 2008 8:40 PM
Crystal Reports, Crystal Reports 6.0, Error 20535, Microsoft Access, Windows Vista
I want to know if it is possible to transfer data from Iseries to a web site and upload some back. This is for our bank and we do not want to use FTP
We need to send files to our bank and receive files back via a web site. What would be the best way. This is the only data we send out of the company now so we would like to do it with what we have and not spend money. We do have a new Iseries [...]
Answer Question
| March 22, 2011 7:21 PM
Data transfer, iSeries, V5R4, WebSphere
We need to send files to our bank and receive files back via a web site. What would be the best way. This is the only data we send out of the company now so we would like to do it with what we have and not spend money. We do have a new Iseries [...]
Answer Question
| March 22, 2011 7:21 PM
Data transfer, iSeries, V5R4, WebSphere
How to stop GF1 info from disappearing
I am using Crystal Reports 2004, version 11.0.0.895. I am writing a report that groups by two fields Customer Name and Invoice Number. Customer Number is Group 1 and Invoice Number is Group 2. I am trying to just show the summary information from Group 1, which sums the information in Group 2. I hide [...]
Answer Question
| July 22, 2008 6:54 PM
Crystal Reports, Crystal Reports 2004, Crystal Reports XI, Grouping
I am using Crystal Reports 2004, version 11.0.0.895. I am writing a report that groups by two fields Customer Name and Invoice Number. Customer Number is Group 1 and Invoice Number is Group 2. I am trying to just show the summary information from Group 1, which sums the information in Group 2. I hide [...]
Answer Question
| July 22, 2008 6:54 PM
Crystal Reports, Crystal Reports 2004, Crystal Reports XI, Grouping
How to calculate my DataBase size
Dear all, I like to calculate my database size , can u tell me the views and formula to calculate my DB size please
Answer Question
| July 22, 2008 1:24 PM
Data modeling, Database design
Dear all, I like to calculate my database size , can u tell me the views and formula to calculate my DB size please
Answer Question
| July 22, 2008 1:24 PM
Data modeling, Database design
how to generate sequece number in an existing table
We are having two datamart one is GDM and other is IDM. Now what to do: 1)Establish a unique royalty_transaction_id in GDM.this should be assigned to every single sales record when inserted in Global_sales_table. 2)Established a reversed royalty transaction id in GDm.This should be assigned to reversed sales transaction and it should point to the [...]
Answer Question
| July 21, 2008 4:20 AM
Data marts, Global Data Mart, International Data Mart, Sequence number generation
We are having two datamart one is GDM and other is IDM. Now what to do: 1)Establish a unique royalty_transaction_id in GDM.this should be assigned to every single sales record when inserted in Global_sales_table. 2)Established a reversed royalty transaction id in GDm.This should be assigned to reversed sales transaction and it should point to the [...]
Answer Question
| July 21, 2008 4:20 AM
Data marts, Global Data Mart, International Data Mart, Sequence number generation
How to access and use subform data/calculations
Access 2007 Database; Employee Info; Form:Sick Days Docking/Pay. I created a form with a subform that keeps track of Employee sick days. It transfers totals from the subform onto the main form…Then the main form does a couple calculations on those amounts…But I need to access that information in a report for each employee. Reports [...]
Answer Question
| July 29, 2008 1:23 PM
Access 2007, Calculations, Database programming, Form, Microsoft Access, Parameters, Reports, Subform, Variable fields
Access 2007 Database; Employee Info; Form:Sick Days Docking/Pay. I created a form with a subform that keeps track of Employee sick days. It transfers totals from the subform onto the main form…Then the main form does a couple calculations on those amounts…But I need to access that information in a report for each employee. Reports [...]
Answer Question
| July 29, 2008 1:23 PM
Access 2007, Calculations, Database programming, Form, Microsoft Access, Parameters, Reports, Subform, Variable fields
how to remove space b/w page footer and report footer in Crystal Report Question
hi im working on .net vs2003 im on working on crystal reports .how can i remove a space b/w page footer and report footer .Atually im not having nothing to display so i suppressed report footer but it is getting a large white space b/w report footer and page footer plz help me
Answer Question
| September 8, 2008 11:16 AM
.NET Framework, Crystal Reports, Crystal Reports 9, Visual Studio 2003, VS 2003
hi im working on .net vs2003 im on working on crystal reports .how can i remove a space b/w page footer and report footer .Atually im not having nothing to display so i suppressed report footer but it is getting a large white space b/w report footer and page footer plz help me
Answer Question
| September 8, 2008 11:16 AM
.NET Framework, Crystal Reports, Crystal Reports 9, Visual Studio 2003, VS 2003
PL/I DB2Stored procedure Execution
How to execute the PL/I DB2 Stored procedure in Mainframe environment?
Answer Question
| July 18, 2008 9:57 AM
DB2, PL/I
How to execute the PL/I DB2 Stored procedure in Mainframe environment?
Answer Question
| July 18, 2008 9:57 AM
DB2, PL/I
DB2 Table Size in V6R1
Upper limitation of Table is 1.7TB in the V5R4 version. How about the limitation in V6R1?
Answer Question
| May 5, 2010 6:38 AM
DB2, V6R1
Upper limitation of Table is 1.7TB in the V5R4 version. How about the limitation in V6R1?
Answer Question
| May 5, 2010 6:38 AM
DB2, V6R1
COBOL date reformatting
I am getting a date from DB2 and I need to reformat it in COBOL. It will eventually be used in DOC1 so I need it to look like a date (i.e. with slashes or dashes). DOC1 was not recognizing the date I am passing in because right now it is just a numerical string, [...]
Answer Question
| May 5, 2010 7:08 PM
COBOL, DB2, DOC1
I am getting a date from DB2 and I need to reformat it in COBOL. It will eventually be used in DOC1 so I need it to look like a date (i.e. with slashes or dashes). DOC1 was not recognizing the date I am passing in because right now it is just a numerical string, [...]
Answer Question
| May 5, 2010 7:08 PM
COBOL, DB2, DOC1
Storing values into a 2-Dimensional Array
Hello, Here I’m directly passing the crystal reports parameters through the code, and generating the report but for some obvious reason, I want the records to be stored first of all into a 2-dimensional array and from there writing it back onto Crystal reports. Note : The reason why I’m looking for 2-Dimensional array is [...]
Answer Question
| July 17, 2008 7:14 PM
2D arrays, Arrays, Crystal Reports, Database programming, Microsoft Access
Hello, Here I’m directly passing the crystal reports parameters through the code, and generating the report but for some obvious reason, I want the records to be stored first of all into a 2-dimensional array and from there writing it back onto Crystal reports. Note : The reason why I’m looking for 2-Dimensional array is [...]
Answer Question
| July 17, 2008 7:14 PM
2D arrays, Arrays, Crystal Reports, Database programming, Microsoft Access
DB2 and talend
I do get the error below when i try to load table in DB2 iseries through ETL tool Talend [IBM][iSeries Access ODBC Driver]Column 6: CWB0111 – A buffer passed to a system call is too small to hold return data can anyone guide me what could be the error
Answer Question
| July 16, 2008 11:30 AM
AS/400 errors, DB2, DB2 Universal Database, iSeries, Talend
I do get the error below when i try to load table in DB2 iseries through ETL tool Talend [IBM][iSeries Access ODBC Driver]Column 6: CWB0111 – A buffer passed to a system call is too small to hold return data can anyone guide me what could be the error
Answer Question
| July 16, 2008 11:30 AM
AS/400 errors, DB2, DB2 Universal Database, iSeries, Talend
Converting the nvarchar datatype in SQL Server 2005
SQL Server 2005 automatically converts all the fields with the nvarchar datatype to nvarchar(MAX), which I can’t use with formula functions in Crystal Reports. Is there a way to stop this conversion to nvarchar(MAX)?
Answer Question
| July 18, 2008 1:51 PM
Crystal Reports, Data Types, NVARCHAR, SQL Server 2005
SQL Server 2005 automatically converts all the fields with the nvarchar datatype to nvarchar(MAX), which I can’t use with formula functions in Crystal Reports. Is there a way to stop this conversion to nvarchar(MAX)?
Answer Question
| July 18, 2008 1:51 PM
Crystal Reports, Data Types, NVARCHAR, SQL Server 2005
how to display gis maps on oracle forms
can any one tell me please. I want to access Arcgis Map on my oracle 6i forms & reports is it possible.
Answer Question
| July 14, 2008 10:09 AM
ArcGIS, Oracle 6i, Oracle Forms, Oracle Reports
can any one tell me please. I want to access Arcgis Map on my oracle 6i forms & reports is it possible.
Answer Question
| July 14, 2008 10:09 AM
ArcGIS, Oracle 6i, Oracle Forms, Oracle Reports
Upgrading from 4.6C to ECC 6.0 in SAP HR
Do we need to execute any conversion programs or other activities to update the payroll schema and processing classes in HR? I ask because there is a change in the U.S. payroll schema on the ECC 6.0 compared to the 4.6c. I request your input and suggestions.”
Answer Question
| July 11, 2008 4:45 AM
ECC4, ECC6, SAP All-in-One, SAP HR
Do we need to execute any conversion programs or other activities to update the payroll schema and processing classes in HR? I ask because there is a change in the U.S. payroll schema on the ECC 6.0 compared to the 4.6c. I request your input and suggestions.”
Answer Question
| July 11, 2008 4:45 AM
ECC4, ECC6, SAP All-in-One, SAP HR
MS Access conversion to CSV files
I am using MS Access 07. Whenever I use the control to export the table as a .csv file, it changes all the fields properties, returning to the “text 255 cha” values. I need specifically to keep the same properties. I used to be able to do it and is not working now.
Answer Question
| July 10, 2008 4:49 PM
CSV, Export, Microsoft Access
I am using MS Access 07. Whenever I use the control to export the table as a .csv file, it changes all the fields properties, returning to the “text 255 cha” values. I need specifically to keep the same properties. I used to be able to do it and is not working now.
Answer Question
| July 10, 2008 4:49 PM
CSV, Export, Microsoft Access
