Electronic Data Distribution
Can anyone provide recommendations of electronic data distribution service providers? i.e. Akamai
Answer Question
| June 11, 2008 8:29 PM
Akamai, Data distribution, Electronic Data Interchange
Can anyone provide recommendations of electronic data distribution service providers? i.e. Akamai
Answer Question
| June 11, 2008 8:29 PM
Akamai, Data distribution, Electronic Data Interchange
Can I build a blog with HTML in a LiveLink custom view?
I need a very basic blog and would like to put it into LiveLink. Any ideas?
Answer Question
| July 25, 2008 8:19 PM
Blogs, HTML, Livelink
I need a very basic blog and would like to put it into LiveLink. Any ideas?
Answer Question
| July 25, 2008 8:19 PM
Blogs, HTML, Livelink
Is it possible convert a mainframe COBOL program to read DB2 data on the mainframe and Oracle data on a server?
I have a mainframe batch COBOL program that reads DB2 data. One of the tables is accessed via a singleton SELECT. The table is being moved to an Oracle database on a Unix server. How do I change the program to be able to access the data in Oracle? Are there different ways to it? [...]
Answer Question
| September 23, 2009 6:37 PM
COBOL, DB2, Mainframe, Oracle, SQL, Unix
I have a mainframe batch COBOL program that reads DB2 data. One of the tables is accessed via a singleton SELECT. The table is being moved to an Oracle database on a Unix server. How do I change the program to be able to access the data in Oracle? Are there different ways to it? [...]
Answer Question
| September 23, 2009 6:37 PM
COBOL, DB2, Mainframe, Oracle, SQL, Unix
DSNTEP2 output problem
DSNTEP2 (aka SPUFI in batch) is causing problems for my extract JCL. How do you get rid of the SPUFI-like column headers from the output datafile produced by DSNTEP2? I don’t have ANY experience with REXX, so an example would be appreciated. Jon
Answer Question
| December 5, 2011 4:49 PM
DB2, DSNTEP2, JCL, REXX, SQL
DSNTEP2 (aka SPUFI in batch) is causing problems for my extract JCL. How do you get rid of the SPUFI-like column headers from the output datafile produced by DSNTEP2? I don’t have ANY experience with REXX, so an example would be appreciated. Jon
Answer Question
| December 5, 2011 4:49 PM
DB2, DSNTEP2, JCL, REXX, SQL
Rookie using DSNTEP2 and IBM JCL – Need Help with JCL
I’d appreciate some help here. My JCL background is HP3000 / MPEX and HP-UX, but my IBM mainframe JCL experience is over ten (10) years old. So I’m having problems creating a JCL – my brain can’t remember command syntax’s from that long ago. I need to create a JCL that will accept an input [...]
Answer Question
| June 11, 2008 1:08 PM
DB2, DSNTEP2, EXEC, JCL, SQL
I’d appreciate some help here. My JCL background is HP3000 / MPEX and HP-UX, but my IBM mainframe JCL experience is over ten (10) years old. So I’m having problems creating a JCL – my brain can’t remember command syntax’s from that long ago. I need to create a JCL that will accept an input [...]
Answer Question
| June 11, 2008 1:08 PM
DB2, DSNTEP2, EXEC, JCL, SQL
Should we use system tables or information schema views to retrieve metadata if both give the same results? Please explain why.
Should we use System tables or Information schema views to retrieve Metadata, since both give the same results, and why?
Answer Question
| June 9, 2008 3:10 PM
Meta data, SQL Server, SQL Server 2005, SYSTEM TABLESPACE
Should we use System tables or Information schema views to retrieve Metadata, since both give the same results, and why?
Answer Question
| June 9, 2008 3:10 PM
Meta data, SQL Server, SQL Server 2005, SYSTEM TABLESPACE
Netapp N5200-G20 & planning for adding an ADIC iScalar2000 LTO4 Library by direct attached (without FC switch).
N5200-G20 and he is planning for adding an ADIC iScalar2000 LTO4 Library by direct attached (without FC switch), do you have experience with this type of setup? If so, didi you configure it and is the FC direct attach supported for ADIC iScalar2000? Also have you used and is there tape support file (TCF file) [...]
Answer Question
| June 9, 2008 2:59 PM
ADIC, iScalar 2000, Library software, NetApp, TCF file
N5200-G20 and he is planning for adding an ADIC iScalar2000 LTO4 Library by direct attached (without FC switch), do you have experience with this type of setup? If so, didi you configure it and is the FC direct attach supported for ADIC iScalar2000? Also have you used and is there tape support file (TCF file) [...]
Answer Question
| June 9, 2008 2:59 PM
ADIC, iScalar 2000, Library software, NetApp, TCF file
tools for intrgration of documentum and lotus notes
what are the tools availabe for the integration between EMC Documentum and lotus notes
Answer Question
| August 2, 2010 9:42 AM
Documentum, Integration, Lotus Notes
what are the tools availabe for the integration between EMC Documentum and lotus notes
Answer Question
| August 2, 2010 9:42 AM
Documentum, Integration, Lotus Notes
error with Jasper Server
java.sql.SQLException: ORA-00923: FROM keyword not found where expected when performing a drill through operation
Answer Question
| July 1, 2009 8:32 PM
JasperServer, ORA-00923, Oracle
java.sql.SQLException: ORA-00923: FROM keyword not found where expected when performing a drill through operation
Answer Question
| July 1, 2009 8:32 PM
JasperServer, ORA-00923, Oracle
V8 CMP EDM Pool
Strobe shows very high CPU in Module DSNGEDM Sections DSNGECMP & DSNGEPUF (which free expanded EDM Pool Storage) for dynamic SQL in a CICS Region. Is this an EDM Pool sizing issue?
Answer Question
| June 25, 2008 7:43 PM
CICS, DB2, DSNGEDM, EDM Pool, SQL
Strobe shows very high CPU in Module DSNGEDM Sections DSNGECMP & DSNGEPUF (which free expanded EDM Pool Storage) for dynamic SQL in a CICS Region. Is this an EDM Pool sizing issue?
Answer Question
| June 25, 2008 7:43 PM
CICS, DB2, DSNGEDM, EDM Pool, SQL
Grep a variable length file in UNIX based on tilde delimiter
Hello: I need to grep a variable length UNIX file. This is a tilde delimited, 21 field file and I need to search for specific values in the 5th field. Please help. My UNIX knowledge is not very extensive. Thanks
Answer Question
| June 6, 2008 7:27 PM
delimited, delimiter, Grep, Unix
Hello: I need to grep a variable length UNIX file. This is a tilde delimited, 21 field file and I need to search for specific values in the 5th field. Please help. My UNIX knowledge is not very extensive. Thanks
Answer Question
| June 6, 2008 7:27 PM
delimited, delimiter, Grep, Unix
hp2015 printing a cms patient screen
When printing a patient screen on cms with the hp2015 it prints in landscape so the whole screen doesnt print out
Answer Question
| June 8, 2012 2:44 PM
CMS, Printers
When printing a patient screen on cms with the hp2015 it prints in landscape so the whole screen doesnt print out
Answer Question
| June 8, 2012 2:44 PM
CMS, Printers
Need help executing MULTIPLE SQL extracts from a JCL
GREYBEARD52: Thanks again for the info, BUT I’m not sure if a CL command can be used with a JCL. Can it? ALSO, my JCL uses the SELECT command, so it appears that the RUNSQLSTM command won’t help – it doesn’t support SELECT. Are there ANY OTHER ALTERNATIVES or a way to tweek this command [...]
Answer Question
| January 27, 2010 6:57 PM
DB2, JCL, SELECT statement, SQL
GREYBEARD52: Thanks again for the info, BUT I’m not sure if a CL command can be used with a JCL. Can it? ALSO, my JCL uses the SELECT command, so it appears that the RUNSQLSTM command won’t help – it doesn’t support SELECT. Are there ANY OTHER ALTERNATIVES or a way to tweek this command [...]
Answer Question
| January 27, 2010 6:57 PM
DB2, JCL, SELECT statement, SQL
EDI running on V5R4 OS iSeries
We are currently looking at upgrading our OS for the iSeries to V5R4. The stopping block is support for EDI and Cyclone. We are in the process of moving EDI to our Unix system the project will not be complete by the time we are scheduled to do the upgrade. EDI and Cyclone say they [...]
Answer Question
| April 23, 2010 5:57 PM
EDI, iSeries applications, V5R4
We are currently looking at upgrading our OS for the iSeries to V5R4. The stopping block is support for EDI and Cyclone. We are in the process of moving EDI to our Unix system the project will not be complete by the time we are scheduled to do the upgrade. EDI and Cyclone say they [...]
Answer Question
| April 23, 2010 5:57 PM
EDI, iSeries applications, V5R4
Creating JCL to execute a large merged file of SQL for DB2
I need to create a JCL that will execute – individually – SQL statements within a merged file (multiple SQL) and write the SQL results to a single output file. Suggestions?
Answer Question
| June 3, 2008 4:55 PM
DB2, JCL, SQL
I need to create a JCL that will execute – individually – SQL statements within a merged file (multiple SQL) and write the SQL results to a single output file. Suggestions?
Answer Question
| June 3, 2008 4:55 PM
DB2, JCL, SQL
Company which is use SAP WMS
Hi, I am looking for the information which company implement and use SAP WMS recently. Also which company did project for that company.
Answer Question
| October 28, 2008 7:33 AM
SAP, SAP WMS, Warehouse Management Systems
Hi, I am looking for the information which company implement and use SAP WMS recently. Also which company did project for that company.
Answer Question
| October 28, 2008 7:33 AM
SAP, SAP WMS, Warehouse Management Systems
How to convert signature in Optio (formerly Forms Express) software
Optio’s electronic forms package supports signature printing directly from an AS/400. We are having trouble with the conversion process which adds the signature to the Optio file. We can get the data from PC to AS/400 and loaded into the first file. Its the next step that fails. Anyone else using this software on V5R3?
Answer Question
| May 31, 2008 10:27 PM
AS/400, Forms Express, Optio Software
Optio’s electronic forms package supports signature printing directly from an AS/400. We are having trouble with the conversion process which adds the signature to the Optio file. We can get the data from PC to AS/400 and loaded into the first file. Its the next step that fails. Anyone else using this software on V5R3?
Answer Question
| May 31, 2008 10:27 PM
AS/400, Forms Express, Optio Software
AS/400 and Oracle Access Manager
I have a strange behavior in an SQLRPGLE program accessing iSeries DB2 and Oracle via Oracle Access Manager. The program is very simple and reads values from two Oracle Tables in this way : a. SELECT …. into ….. FROM Table1 WHERE ….. return OK : 1 row as expected with my two fields filled. [...]
Answer Question
| April 22, 2010 3:58 PM
AS/400, DB2, iSeries DB2, Oracle Access Manager, RPGLE, SQL, SQLRPGLE
I have a strange behavior in an SQLRPGLE program accessing iSeries DB2 and Oracle via Oracle Access Manager. The program is very simple and reads values from two Oracle Tables in this way : a. SELECT …. into ….. FROM Table1 WHERE ….. return OK : 1 row as expected with my two fields filled. [...]
Answer Question
| April 22, 2010 3:58 PM
AS/400, DB2, iSeries DB2, Oracle Access Manager, RPGLE, SQL, SQLRPGLE
Using IFS to view reports
I am just learning about IFS and I am wondering if anyone is using this process to allow users to view reports online. We currently still print reports and we were thinking we could somehow store them online then maybe use IFS to allow access to get at them. Currently, our users have a restricted [...]
Answer Question
| May 29, 2008 3:00 PM
IFS, Integrated File System (IFS), Reports
I am just learning about IFS and I am wondering if anyone is using this process to allow users to view reports online. We currently still print reports and we were thinking we could somehow store them online then maybe use IFS to allow access to get at them. Currently, our users have a restricted [...]
Answer Question
| May 29, 2008 3:00 PM
IFS, Integrated File System (IFS), Reports
Data Modeling Tools for relational database & dimensional data mart
I am working with both an Oracle relational database as well as an Oracle data mart, with snowflake schema. Do I need a particular modeling tool to reverse engineer the data mart to produce a data model diagram? Presently I am using Toad Data Modeler to produce a data model for the transaction database.
Answer Question
| May 31, 2008 2:27 PM
Data mart, Data Model Diagram, Data modeling, Oracle, Oracle Data Mart, Relational databases, Snowflake Schema, Toad Data Modeler
I am working with both an Oracle relational database as well as an Oracle data mart, with snowflake schema. Do I need a particular modeling tool to reverse engineer the data mart to produce a data model diagram? Presently I am using Toad Data Modeler to produce a data model for the transaction database.
Answer Question
| May 31, 2008 2:27 PM
Data mart, Data Model Diagram, Data modeling, Oracle, Oracle Data Mart, Relational databases, Snowflake Schema, Toad Data Modeler
