Change IDOC for ORDCHG behavior
We are receiving EDI documents from a trading partner that we wish to process as order changes. To that end we are using the Basic Type ORDERS01 and a Logical Message Type of ORDCHG. The partner relationships have been defined to support this relationship and ORDCHG transactions are being successfully processed, though not as expected. [...]
Answer Question
| January 24, 2008 2:03 PM
iDoc, ORDCHG, SAP
We are receiving EDI documents from a trading partner that we wish to process as order changes. To that end we are using the Basic Type ORDERS01 and a Logical Message Type of ORDCHG. The partner relationships have been defined to support this relationship and ORDCHG transactions are being successfully processed, though not as expected. [...]
Answer Question
| January 24, 2008 2:03 PM
iDoc, ORDCHG, SAP
Lotus Notes and AS400 (DB2)
I have a form in Notes where a user enters a reference number. When the user clicks the submit button I want to Validate their reference number against a table on our AS400. I am able to do this with an ODBC connection on my workstation but… MANAGEMNT does not want users to have any [...]
Answer Question
| January 22, 2008 5:55 PM
AS/400, DB2, Lotus Domino, Lotus Notes
I have a form in Notes where a user enters a reference number. When the user clicks the submit button I want to Validate their reference number against a table on our AS400. I am able to do this with an ODBC connection on my workstation but… MANAGEMNT does not want users to have any [...]
Answer Question
| January 22, 2008 5:55 PM
AS/400, DB2, Lotus Domino, Lotus Notes
Export tabels from SQL Server to iSeries
I have a need to export a table on an SQL server to a file on the iSeries. I would also like this to be automated so that when the table is populated, the information is automatically exported to the file on the iSeries. I have tried using DTS/Enterprise Manager, but to no avail. Any [...]
Answer Question
| August 12, 2009 4:51 PM
Export, iSeries programming commands, SQL
I have a need to export a table on an SQL server to a file on the iSeries. I would also like this to be automated so that when the table is populated, the information is automatically exported to the file on the iSeries. I have tried using DTS/Enterprise Manager, but to no avail. Any [...]
Answer Question
| August 12, 2009 4:51 PM
Export, iSeries programming commands, SQL
How to insert a CMS (Doop) page into a separate page using PHP?
This seems like it would be fairly simple but I’m coming up empty so far. I have installed DOOP, a very simple CMS. I put it into its own folder in my website root. What I want is for a particular DOOP page, let’s say the home page http://mywebsite.com/cms/index.php?page=1home to display on another page – [...]
Answer Question
| February 7, 2008 3:32 AM
CMS, Doop, iFrame, PHP, Web development
This seems like it would be fairly simple but I’m coming up empty so far. I have installed DOOP, a very simple CMS. I put it into its own folder in my website root. What I want is for a particular DOOP page, let’s say the home page http://mywebsite.com/cms/index.php?page=1home to display on another page – [...]
Answer Question
| February 7, 2008 3:32 AM
CMS, Doop, iFrame, PHP, Web development
File sort using qshell (this time with tags)
Hi, I’m trying to use qshell to do a sort of a (non-keyed) DB2 database file to remove duplicate records. I use the following command :- sort -u /QSYS.LIB/$1.LIB/$2.FILE/$3.MBR | cat > /QSYS.LIB/$1.LIB/$2.FILE/$3.MBR Where $1 = Library name, $2 = File name, $3 = Member name. The command does a sort, removing duplicate records, and [...]
Answer Question
| January 16, 2008 3:12 PM
AS/400, Database, DB2, Linux, Qshell, Unix shells
Hi, I’m trying to use qshell to do a sort of a (non-keyed) DB2 database file to remove duplicate records. I use the following command :- sort -u /QSYS.LIB/$1.LIB/$2.FILE/$3.MBR | cat > /QSYS.LIB/$1.LIB/$2.FILE/$3.MBR Where $1 = Library name, $2 = File name, $3 = Member name. The command does a sort, removing duplicate records, and [...]
Answer Question
| January 16, 2008 3:12 PM
AS/400, Database, DB2, Linux, Qshell, Unix shells
How to use PL/I command LIKE with DB2
I wont to use PL/I comman like for using same structure twice. Compiler returns error : IBM7043I S 4.1 SQL0314N The host variable “xxxxxxxx” is incorrectly declared. SQLSTATE=00000 IBM7043I S 9.1 SQL0117N The number of values assigned is not the same as the number of specified or implied columns. SQLSTATE=42802 Is there eny way to [...]
Answer Question
| March 8, 2010 2:57 PM
DB2, iSeries programming commands, PL/I
I wont to use PL/I comman like for using same structure twice. Compiler returns error : IBM7043I S 4.1 SQL0314N The host variable “xxxxxxxx” is incorrectly declared. SQLSTATE=00000 IBM7043I S 9.1 SQL0117N The number of values assigned is not the same as the number of specified or implied columns. SQLSTATE=42802 Is there eny way to [...]
Answer Question
| March 8, 2010 2:57 PM
DB2, iSeries programming commands, PL/I
Crystal report
I have to show treeview on Group header of my report.Is there any functionality in crystal report to set tree view on any group header like pivote table in Excel.
Answer Question
| January 16, 2008 8:57 AM
Crystal Reports, TreeView
I have to show treeview on Group header of my report.Is there any functionality in crystal report to set tree view on any group header like pivote table in Excel.
Answer Question
| January 16, 2008 8:57 AM
Crystal Reports, TreeView
How to replace SAS
Hi, I am an performance expert and more and more customers are having issues with bad performing SAS applications. Is there a product out there that uses the SAS code, but runs it in an much more optimal way? Thx. Johannes Peeters Trilog Expert / AQM Solutions johannes.peeters@trilogexpert.com
Answer Question
| January 14, 2008 2:13 PM
Business intelligence software, SAS, SAS Institute
Hi, I am an performance expert and more and more customers are having issues with bad performing SAS applications. Is there a product out there that uses the SAS code, but runs it in an much more optimal way? Thx. Johannes Peeters Trilog Expert / AQM Solutions johannes.peeters@trilogexpert.com
Answer Question
| January 14, 2008 2:13 PM
Business intelligence software, SAS, SAS Institute
oracle calculated item
hi ihave alist of variables some of them calculated from others i recieved them from certain source in certain date and i have alist of indicatores which are calculated from the variables (for the same date,& source) but every indicator has diffrent equation & the user need to modify the equation f needed and define [...]
Answer Question
| January 14, 2008 1:12 PM
Database Management Systems, DB2, Oracle, Oracle 6i, USE DATABASE
hi ihave alist of variables some of them calculated from others i recieved them from certain source in certain date and i have alist of indicatores which are calculated from the variables (for the same date,& source) but every indicator has diffrent equation & the user need to modify the equation f needed and define [...]
Answer Question
| January 14, 2008 1:12 PM
Database Management Systems, DB2, Oracle, Oracle 6i, USE DATABASE
is anyone familiar with a modeling method called JUMP
I am tasked with a data integration project and client are asking about a modeling language called JUMP. I found some information on web and on sourceforge for a Jumper project. Has anyone used this or heard of this? Please advise
Answer Question
| February 21, 2008 7:44 PM
Data cleansing software, Data integration, Data modeling, Data quality tools
I am tasked with a data integration project and client are asking about a modeling language called JUMP. I found some information on web and on sourceforge for a Jumper project. Has anyone used this or heard of this? Please advise
Answer Question
| February 21, 2008 7:44 PM
Data cleansing software, Data integration, Data modeling, Data quality tools
Data warehouse vs Database
What is the difference between a database and a data warehouse?
Answer Question
| April 19, 2013 1:40 AM
Data base design, Data warehouse
What is the difference between a database and a data warehouse?
Answer Question
| April 19, 2013 1:40 AM
Data base design, Data warehouse
formatting excel using lotusscript
I would like to know how can I draw borders on a cell in excel with lotusscript? I’ve goggled for sites that give excel exporting tutorial but none provides a detailed explanation. Any suggestions?
Answer Question
| January 4, 2008 2:56 AM
Export, LotusScript, Microsoft Excel
I would like to know how can I draw borders on a cell in excel with lotusscript? I’ve goggled for sites that give excel exporting tutorial but none provides a detailed explanation. Any suggestions?
Answer Question
| January 4, 2008 2:56 AM
Export, LotusScript, Microsoft Excel
Roles of an IT resource supporting ACAD Operations
what roles do i look for in a resource who will support a AutoCAD Engineering Center
Answer Question
| January 1, 2008 3:14 PM
AutoCAD, IT management services
what roles do i look for in a resource who will support a AutoCAD Engineering Center
Answer Question
| January 1, 2008 3:14 PM
AutoCAD, IT management services
Best way to do streaming video?
Hello, I have been asked to research some info for my church about a better way to view our service videos on the web… Currently, we are using a company that designed and hosts our website. We ftp what we want on the website…. Currently, we put our WMV files (Most are around 115mb or [...]
Answer Question
| December 31, 2007 5:00 PM
File Hosting, Pod Casting, RSS, Streaming Video
Hello, I have been asked to research some info for my church about a better way to view our service videos on the web… Currently, we are using a company that designed and hosts our website. We ftp what we want on the website…. Currently, we put our WMV files (Most are around 115mb or [...]
Answer Question
| December 31, 2007 5:00 PM
File Hosting, Pod Casting, RSS, Streaming Video
How do I connect SAS with Sybase?
Please help me to connect the SAS engine with Sybase data base server. Thanks! Bala
Answer Question
| December 27, 2007 11:54 AM
SAS, Sybase
Please help me to connect the SAS engine with Sybase data base server. Thanks! Bala
Answer Question
| December 27, 2007 11:54 AM
SAS, Sybase
Archive Storage and Retrieval
I am the IT Director at my church but have a limited amount of experience with software. My back ground is Hardware, Networking, video, audio and other. One of my commitees came to me a couple of weeks ago and is asking me for help. The project is to take the Church’s past history, since [...]
Answer Question
| December 18, 2007 7:53 PM
Archival software, Catalog software, Database Management Systems, Document archive, Document retrieval, Library software, Scanning
I am the IT Director at my church but have a limited amount of experience with software. My back ground is Hardware, Networking, video, audio and other. One of my commitees came to me a couple of weeks ago and is asking me for help. The project is to take the Church’s past history, since [...]
Answer Question
| December 18, 2007 7:53 PM
Archival software, Catalog software, Database Management Systems, Document archive, Document retrieval, Library software, Scanning
loading data from ods to cube
can u tell me y should we first load data into the ods and then into the cube?? please give examples …. If it is done in specific cases only where the need of the situation demands then please give me examples of such situations.
Answer Question
| July 28, 2010 6:00 AM
InfoCube, ODS (Operational Data Store), SAP analytics and reporting, SAP BI
can u tell me y should we first load data into the ods and then into the cube?? please give examples …. If it is done in specific cases only where the need of the situation demands then please give me examples of such situations.
Answer Question
| July 28, 2010 6:00 AM
InfoCube, ODS (Operational Data Store), SAP analytics and reporting, SAP BI
Crystal Reports
I am a novice in Crystal and I am trying to create a funtion that will read more than one record to give me the result. The formula I have now is only reading the first record and I am not sure how to get it to read every record. The formula is as follows: [...]
Answer Question
| December 7, 2007 6:15 PM
Crystal Reports
I am a novice in Crystal and I am trying to create a funtion that will read more than one record to give me the result. The formula I have now is only reading the first record and I am not sure how to get it to read every record. The formula is as follows: [...]
Answer Question
| December 7, 2007 6:15 PM
Crystal Reports
Delete ODS request via Process Chain
Hello Guru: How can I delete all requests in ODS via Process chain; except last day of the week and last they of the month I do not want to delete. thanks
Answer Question
| December 6, 2007 8:50 PM
DELETE statement, ODS (Operational Data Store), Process chain
Hello Guru: How can I delete all requests in ODS via Process chain; except last day of the week and last they of the month I do not want to delete. thanks
Answer Question
| December 6, 2007 8:50 PM
DELETE statement, ODS (Operational Data Store), Process chain
IDoc creation function not returning Idoc number
Hi. I am working on the requirement to send data from SAP to non-SAP system and I using the IDoc creation function ‘MASTER_IDOC_DISTRIBUTE’. I am having issue with it. It is not returning Idoc numbers that it created even though it has in Table parameter COMMUNICATION_IDOC_CONTROL = I_EDIDC. I checked everything and it looks fine. [...]
Answer Question
| March 18, 2008 2:21 AM
iDoc, SAP development
Hi. I am working on the requirement to send data from SAP to non-SAP system and I using the IDoc creation function ‘MASTER_IDOC_DISTRIBUTE’. I am having issue with it. It is not returning Idoc numbers that it created even though it has in Table parameter COMMUNICATION_IDOC_CONTROL = I_EDIDC. I checked everything and it looks fine. [...]
Answer Question
| March 18, 2008 2:21 AM
iDoc, SAP development
