Create DB2 table relations
Without RI or a really good data dictionary you are essentially out of luck for doing this completely automatically. You’ll need to get somebody to at least define the relationship to you — there are ways to deduce relationships based on table names / column names etc. but you can’t be guaranteed that your interpretation [...]
View Answer
| November 24, 2008 8:43 PM
DB2, DB2 Table Relationships, Mapping table relationships, Table Relationships
Without RI or a really good data dictionary you are essentially out of luck for doing this completely automatically. You’ll need to get somebody to at least define the relationship to you — there are ways to deduce relationships based on table names / column names etc. but you can’t be guaranteed that your interpretation [...]
View Answer
| November 24, 2008 8:43 PM
DB2, DB2 Table Relationships, Mapping table relationships, Table Relationships
Replicating SAN to DR Site
Some ideas based on what we have done with clients – we’ve found some really good unified gateway appliances that you can hook up to one SAN site. You can take a snap copy of your production data/volume so you don’t disrupt your current environment. Then you do WAN replication to a similar appliance at [...]
View Answer
| November 24, 2008 5:39 PM
Data Replication, Disaster Recovery, Disaster recovery planning, DR, SAN, WAN
Some ideas based on what we have done with clients – we’ve found some really good unified gateway appliances that you can hook up to one SAN site. You can take a snap copy of your production data/volume so you don’t disrupt your current environment. Then you do WAN replication to a similar appliance at [...]
View Answer
| November 24, 2008 5:39 PM
Data Replication, Disaster Recovery, Disaster recovery planning, DR, SAN, WAN
Knowledge management (KM) system for large organisation?
<i>ANSWER 1 from ?</i> I know how frustrating researching knowledge base software can be. I did a little keyword searching for you on www.sourceforge.net and was able to find a legal case management software that mey meet your needs. I hope this helps. Here’s the link : <a href=”http://www.lcm.ngo-bg.org/article45.html”>http://www.lcm.ngo-bg.org/article45.html</a> ——————————————————————————————– <i>ANSWER 2 from Gregory Culpin</i> [...]
View Answer
| November 21, 2008 5:36 PM
Database, Knowledge management, Knowledge management applications, Knowledge Management Software
<i>ANSWER 1 from ?</i> I know how frustrating researching knowledge base software can be. I did a little keyword searching for you on www.sourceforge.net and was able to find a legal case management software that mey meet your needs. I hope this helps. Here’s the link : <a href=”http://www.lcm.ngo-bg.org/article45.html”>http://www.lcm.ngo-bg.org/article45.html</a> ——————————————————————————————– <i>ANSWER 2 from Gregory Culpin</i> [...]
View Answer
| November 21, 2008 5:36 PM
Database, Knowledge management, Knowledge management applications, Knowledge Management Software
How do I read in the comma delimited files by SAS
As for the Excel part, saving each sheet as a different CSV file is the only option, because excel will just save the current sheet, so you need to go to the first sheet, go to files->save as and select the CSV format. Then you need to do the same with the second sheet. <b>About [...]
View Answer
| November 20, 2008 7:04 PM
CSV, Delimited function, Microsoft Excel, SAS
As for the Excel part, saving each sheet as a different CSV file is the only option, because excel will just save the current sheet, so you need to go to the first sheet, go to files->save as and select the CSV format. Then you need to do the same with the second sheet. <b>About [...]
View Answer
| November 20, 2008 7:04 PM
CSV, Delimited function, Microsoft Excel, SAS
Crystal Report Query – Customers with Multiple Products
You could use a different status for that policies that were not really cancelled by a client’s request, but reassigned to another PID for any reason. Something like ANNULLED, or similar. Or you could add a new field to the table (if that is an option) to store a cancellation reason, so you can differentiate [...]
View Answer
| November 20, 2008 12:18 AM
Crystal Reports, Crystal Reports 10
You could use a different status for that policies that were not really cancelled by a client’s request, but reassigned to another PID for any reason. Something like ANNULLED, or similar. Or you could add a new field to the table (if that is an option) to store a cancellation reason, so you can differentiate [...]
View Answer
| November 20, 2008 12:18 AM
Crystal Reports, Crystal Reports 10
Export Attachmets
If you are referring to the linked or attached TABLES in Access, you can pull that out of the tables collection using VBA. To run my sample code, First create a table called “TableLinks” with text columns called Name and Connect. Then paste this code into a module and run it: Public Sub LoadTableLinks() Dim [...]
View Answer
| November 19, 2008 8:23 PM
Access 2007, Access Database, Access Database Attachments, Export, Microsoft Access
If you are referring to the linked or attached TABLES in Access, you can pull that out of the tables collection using VBA. To run my sample code, First create a table called “TableLinks” with text columns called Name and Connect. Then paste this code into a module and run it: Public Sub LoadTableLinks() Dim [...]
View Answer
| November 19, 2008 8:23 PM
Access 2007, Access Database, Access Database Attachments, Export, Microsoft Access
Update help needed
I think you could try changing your syntax to something like this: <pre>Update LIBNAME.DXFILE Set DXDNAM = ”, DXDAD1 = ”, DXDAD2 = ”, DXDAD3 = ”, DXDAD4 = ”, DXDPCD = ”, DXINVN = 0 from IBNAME.SDFILE Inner Join LIBNAME.DXFILE On SDPRDC = DXPRDC And SDSENO = DXSENO And SDORNO = DXORNO And SDLINE [...]
View Answer
| November 18, 2008 7:29 PM
DB2, i5, SQL, UDB for iSeries/i5
I think you could try changing your syntax to something like this: <pre>Update LIBNAME.DXFILE Set DXDNAM = ”, DXDAD1 = ”, DXDAD2 = ”, DXDAD3 = ”, DXDAD4 = ”, DXDPCD = ”, DXINVN = 0 from IBNAME.SDFILE Inner Join LIBNAME.DXFILE On SDPRDC = DXPRDC And SDSENO = DXSENO And SDORNO = DXORNO And SDLINE [...]
View Answer
| November 18, 2008 7:29 PM
DB2, i5, SQL, UDB for iSeries/i5
DB2/400
DB2/400 is databse of AS/400. Here we have Physical & Logical file concept. Different data types.
View Answer
| November 13, 2008 9:52 AM
DB2, DB2/400, IBM DB2
DB2/400 is databse of AS/400. Here we have Physical & Logical file concept. Different data types.
View Answer
| November 13, 2008 9:52 AM
DB2, DB2/400, IBM DB2
MS Access & EDI
You will have to explain better what you mean about a database that uses EDI. MS Access can interface with many databases using ODBC. Simply create links to the tables or views that you want to access in the other database. EDI implies formatted input and output, you can create those using queries. Maybe some [...]
View Answer
| November 11, 2008 10:02 PM
Access, Database Management Systems, DBMS, EDI, Electronic Data Interchange, Microsoft Access
You will have to explain better what you mean about a database that uses EDI. MS Access can interface with many databases using ODBC. Simply create links to the tables or views that you want to access in the other database. EDI implies formatted input and output, you can create those using queries. Maybe some [...]
View Answer
| November 11, 2008 10:02 PM
Access, Database Management Systems, DBMS, EDI, Electronic Data Interchange, Microsoft Access
Barcode printing and afp
There are several references to this type of question within this Knowledge Exchange. If you do a search for Barcode you will find where there are several answers to this question… See website for additional information… http://www.itjungle.com/fhg/fhg062304-story02.html use Display Device Description (DSPDEVD) to check the host print transform attribute. It needs to have a value [...]
View Answer
| November 11, 2008 9:46 PM
AFP, AS/400 printing, Barcode, Barcode AFP Utility
There are several references to this type of question within this Knowledge Exchange. If you do a search for Barcode you will find where there are several answers to this question… See website for additional information… http://www.itjungle.com/fhg/fhg062304-story02.html use Display Device Description (DSPDEVD) to check the host print transform attribute. It needs to have a value [...]
View Answer
| November 11, 2008 9:46 PM
AFP, AS/400 printing, Barcode, Barcode AFP Utility
Cross-platform tools for security, monitoring
<a href=”http://www.smoothwall.org”>Smoothwall</a> or <a href=”http://cobia.stillsecure.com/”>Cobia</a> might fit your requirements. <a href=”http://filezilla-project.org/”>Filezilla</a> is a good secure FTP server & client solution.
View Answer
| November 11, 2008 5:51 PM
Debian, Integration, Linux monitoring and troubleshooting, Monitoring, Network monitoring
<a href=”http://www.smoothwall.org”>Smoothwall</a> or <a href=”http://cobia.stillsecure.com/”>Cobia</a> might fit your requirements. <a href=”http://filezilla-project.org/”>Filezilla</a> is a good secure FTP server & client solution.
View Answer
| November 11, 2008 5:51 PM
Debian, Integration, Linux monitoring and troubleshooting, Monitoring, Network monitoring
Becoming a Freelance Developer
Your decision should be based on how either option (and others) fits your long term future plans. Not only what will you be earning, but what will you be learning? The advantage of working at a place like McDonald’s is that you will be interacting with people – customers, management and fellow employees, in a [...]
View Answer
| November 9, 2008 11:27 PM
Career development, Development, E-business, Linux, Programming Languages
Your decision should be based on how either option (and others) fits your long term future plans. Not only what will you be earning, but what will you be learning? The advantage of working at a place like McDonald’s is that you will be interacting with people – customers, management and fellow employees, in a [...]
View Answer
| November 9, 2008 11:27 PM
Career development, Development, E-business, Linux, Programming Languages
How does Amazon.com use database management systems?
Pretty much everything that you see on Amazon’s web page is going to be database driven. All your purchase data is stored a database. They use this data to figure out which products you might like based on other peoples purchase history. Every time you view a product that information is logged so that they [...]
View Answer
| November 9, 2008 6:26 AM
Amazon, Database Management Systems, DBMS, RDBMS, Relational database management systems
Pretty much everything that you see on Amazon’s web page is going to be database driven. All your purchase data is stored a database. They use this data to figure out which products you might like based on other peoples purchase history. Every time you view a product that information is logged so that they [...]
View Answer
| November 9, 2008 6:26 AM
Amazon, Database Management Systems, DBMS, RDBMS, Relational database management systems
SSIS package
Without more information as to what the job is suppose to do, not really.
View Answer
| November 6, 2008 6:13 PM
Business Intelligence, SQL Server 2005, SQL Server 2005 Integration Services, SQL Server Integration Services, SQL Server stored procedures, SSIS Package, Stored Procedures
Without more information as to what the job is suppose to do, not really.
View Answer
| November 6, 2008 6:13 PM
Business Intelligence, SQL Server 2005, SQL Server 2005 Integration Services, SQL Server Integration Services, SQL Server stored procedures, SSIS Package, Stored Procedures
PDF format file change to Excel
PDF is a format for output and review, not a source format intended for editing. For editing purposes you could use the full Adobe Acrobat, or there are several free editing tools available (although I cannot personally vouch for any of those, have just used the original program when necessary) Here are a couple of [...]
View Answer
| November 5, 2008 5:40 PM
Data conversion, Excel import/export, File formats, Microsoft Excel, PDF, PDF to Excel
PDF is a format for output and review, not a source format intended for editing. For editing purposes you could use the full Adobe Acrobat, or there are several free editing tools available (although I cannot personally vouch for any of those, have just used the original program when necessary) Here are a couple of [...]
View Answer
| November 5, 2008 5:40 PM
Data conversion, Excel import/export, File formats, Microsoft Excel, PDF, PDF to Excel
Concurrent users
I got around the same thing by creating a wrapper program with a file. Everytime some one chooses the option the file is checked for number of users and will deny access if the concurrent limit has been reached. I display a screen of current users so the rejected can approach other users to back [...]
View Answer
| November 5, 2008 3:22 PM
AS/400 user permissions, ERP
I got around the same thing by creating a wrapper program with a file. Everytime some one chooses the option the file is checked for number of users and will deny access if the concurrent limit has been reached. I display a screen of current users so the rejected can approach other users to back [...]
View Answer
| November 5, 2008 3:22 PM
AS/400 user permissions, ERP
FORMAT keyword in non-join logical files — what and how?
The format keyword isn’t used in this way very often. It allow you to create a logical over one file but use the formating of another file. File1 contains fields FLDA, FLDB, FLDC and FLDD File2contains fields FLDA, FLDB, FLDC Logical1 is created over file1 and would contain the four fields Logical2 is created over [...]
View Answer
| November 4, 2008 6:14 PM
DB2, FORMAT keyword, Logical File
The format keyword isn’t used in this way very often. It allow you to create a logical over one file but use the formating of another file. File1 contains fields FLDA, FLDB, FLDC and FLDD File2contains fields FLDA, FLDB, FLDC Logical1 is created over file1 and would contain the four fields Logical2 is created over [...]
View Answer
| November 4, 2008 6:14 PM
DB2, FORMAT keyword, Logical File
Spool to Flat
Sure Spool to flat — CPYSPLF if you want to be able to use it later with printer controls (lf’s and page) – make the physical file one character wider – use control *FCFC – first column of physical file will contain codes for lf & new page Physical to Spool – CPYF the to [...]
View Answer
| November 4, 2008 2:35 PM
File conversion, File formats, Flat files, Flat to Spool, Spool files, Spool to Flat
Sure Spool to flat — CPYSPLF if you want to be able to use it later with printer controls (lf’s and page) – make the physical file one character wider – use control *FCFC – first column of physical file will contain codes for lf & new page Physical to Spool – CPYF the to [...]
View Answer
| November 4, 2008 2:35 PM
File conversion, File formats, Flat files, Flat to Spool, Spool files, Spool to Flat
Barcoding in RPG/400 DDS
We need info before we can respond Do you have an IBM or similiar printer that is IPDS capable and supports EAN13 – <b><ul> YES Can you create an AFPDS printer file with the BARCODE keyword and RPG or COBOL code to call it? <b></ul> YES Do you need info on the BARCODE keyword??? </b><ul> [...]
View Answer
| November 4, 2008 12:06 PM
Barcode, Data Description Specifications, DDS, EAN-13, RPG, RPG/400
We need info before we can respond Do you have an IBM or similiar printer that is IPDS capable and supports EAN13 – <b><ul> YES Can you create an AFPDS printer file with the BARCODE keyword and RPG or COBOL code to call it? <b></ul> YES Do you need info on the BARCODE keyword??? </b><ul> [...]
View Answer
| November 4, 2008 12:06 PM
Barcode, Data Description Specifications, DDS, EAN-13, RPG, RPG/400
What is a data point?
In general, a data point is anything that you can define and measure. Pertaining to networks, you are looking at things like latency or connection speed.
View Answer
| November 3, 2008 9:04 PM
Data, Data point, Network monitoring, Networking
In general, a data point is anything that you can define and measure. Pertaining to networks, you are looking at things like latency or connection speed.
View Answer
| November 3, 2008 9:04 PM
Data, Data point, Network monitoring, Networking
