DataManagement

Coding to prevent table overflows withing programs

In this new world of zero tollerance for abends and the goal of 100% production stability, I have been charged with determining the best method to prevent abends due to internal program table overflows.  Our environment has Cobol, Eztrieve and Assembler programs with internal tables.  We are...

How to combine 2 linked Excel tables in access 2003 with same field names, using query?

I have 3 employees working who have no access on their PC. they are performing their data entry in excel and I ahve linked all three tables to one access file as I have Access on my PC. I need to combine all 3 tables using query or some other method in access to create one master table. Here is the...

Record Count Crystal Reports 2008

I currently have a report where data pulls from a table labeled clients for things such as patient name, address, etc.  However, I would also like to get a count of orders that the client has made.  These orders are stored in a separate table and not counted, but linked by a client id number. ...

The IT Blog Top 10: Nov. 5, 2009

10. Using VRDP to view VirtualBox virtual machines remotely Rick Vanover has put together a useful tutorial for Sun’s xVM VirtualBox. 9. How to reset the Cisco Catalyst Switch to Factory Defaults Yasir Irfan offers some advice for those needing a fresh late on Catalyst switches. 8. Independent...

Troubleshooting Data Mining in SQL Server Analysis Services 2005

I want to run the Data Mining tool in SQL Server Analysis Services 2005, but I can only get to the processing stage: It hangs (NOT RESPONDING) when I try to go into the Mining Model Viewer. Could this be a PC or SQL config problem? How do I resolve this problem?     Software/Hardware used:...

The most-watched IT questions this week: Nov. 3, 2009

Here are the 10 most watched questions on ITKE: There’s some great discussions going on. Go answer a question now and take your shot at winning a TV: 1. Problem installing Exchange 2007 Management Tools was posed by Labnuke99 and answered by Mshen. 2. What Event ID was asked by Newbiepeon and...

Crystal 9 Subreport will not run

I have a Crystal 9 report that is working properly, but the sub report (also in Crystal 9), will not run.  I have tried removing it and re-adding it with a new connection and it still will not run.  Everything appears to be linked properly, but yet it will not open. Thanks; Gillian ...

db2/400

Hi, on db2 hw to give the output query using webquery and consoal? And what is the meaning of webquery and consol?

Procedure Pointer

How to use a procedure pointer? Other than procedures where pointers concept can be applicable in AS/400? Software/Hardware used: Iseries

The IT Blog Top 10: Oct. 29, 2009

10. Choosing a block size when creating VMFS datastores Eric Siebert has written a guide on how to choose the right size for VMFS datastores. 9. How to use command line arguments in VBScript via the Wscript.Arguments Object Jerry Lees explains a helpful VBScript trick. 8. Using VRDP to view...

Workstation ID/IP Address

HI, I have a situation we have made 500 device description (e.g. IT01, IT02...) for display and assigned each workstation id to user. After creating devices we changed the system value QAUTOCFG=0 and QAUTOVRT=0. Now If A user is using B user worksation ID so B user is unable to get signon screen...

External DB2 Database link/trigger

In Oracle I can register a database link to other data sources. For example, through ODBC I have registered DB2 as a database link. In this way I can read/insert/update from/into DB2 tables. Software/Hardware used: i5 i5/os v5m4

SPSS Binary Regression

Please could you help me out. 1) Question I have a binary question. It involves the sex op people being surveyed. I have to enter (into SPSS) if there are "Male" or "Female". After I have entered "Male" or "Female" can SPSS convert "0" for Male and "1" for "Female"? Thanks. Software/Hardware...

Windows Server and Crystal Reports

I upgraded to Windows Server 2008. Now when I try to display or print a Crystal Report from my application it throws me out of the application. My Crystal Reports version is 8.5.0.217 Do I need an update to Crystal Reports to get this to work on a Windows Server 2008?

AS/400 file transfer window disappears

as400 file transfer window drops to the bottom never to return.

Can anyone tell me how to put more space between the dimension text and fraction of an inch at the end of the text? I assume it is a dim variable.

When dimemsioning in achitectural format, there is almost no space between the inch and fraction of an inch in the end ot the dimension text. Does anyone know if there is a dimension variable for incrasing this space, or any other way? Thanks for your help. I'm using Acad 2008, but had this...

Is the new WRKDBF out yet?

Anyone heard if the efforts to recreate a WRKDBF utility have borne fruit yet? Once again I find myself needing a general purpose file view utility, and hover on the brink of writing something, for I saw somewhere that a new one was being put together. Software/Hardware used: i5 v5r4

Count distinct values in Proc Tabulate

Hi How can you count distinct values in a Proc Tabulate table? E.g. if you want to count distinct customer numbers. Much like count(distinct(customer_number)) in SQL. Regards, Laurits Software/Hardware used: SAS Base 9.3.1

STORED PROCEDURE

Hi All i search to make procedure in strsql please can anybody help me and search code open text file from the procedure and put data on  it   Software/Hardware used: AS/400 sql400 DB2

The most-watched IT questions this week: Oct. 20, 2009

Here are the 5 most watched questions on ITKE: There's some great discussions going on ranging from SQL to diagnosing app crashes. Go answer a question now and take your shot at winning a TV, or check out the rest of the top 10 on the Community Blog: 1.ORA-31672 in oracle 11g tops the list, with...