data base files
Hi, The negatives are stored with a sign in the rightmost position of the field – the sign is normally a letter and is dependent upon the rightmost digit in the value. This sounds more confusing than it is and you don’t really need to know too much about it in practice. To enter negative [...]

View Answer   |  July 29, 2009  2:54 PM
DB2, PF

How to select 1 record in DB2
SELECT * FROM <TABLE_NAME> FETCH FIRST 1 ROW ONLY -- FOR MULTIPLE ROWS SELECT * FROM <TABLE_NAME> FETCH FIRST <NUM> ROWS ONLY Please let me know if you need any information -Vijay Kanth Hello, In a relational design, you first have to answer the question “first what?” The previous example will return 1 row, but [...]

View Answer   |  April 18, 2013  2:24 PM
DB2, SELECT statement

DBCS “open data type” problem – time-critical situation
This <a href=”http://publib.boulder.ibm.com/infocenter/iseries/v5r4/topic/rzakb/ldata.htm”>chart</a> documents the valid mappings across data types. O to A is not shown as a valid mapping (which I don’t find too surprising as O is mixed SBCS and DBCS). The table does however show O to UTF8 as being valid. UTF8 is treated as character data so that might work in [...]

View Answer   |  July 29, 2009  12:04 PM
Data conversion, DBCS, Logical File, open data type

I use crystal report version 1o
Try this instead <pre> if({SALESTABLE.CUSTACCOUNT} = “0012″ <b>AND</b> {SALESTABLE.INTERCOMPANYCOMPANYID}) = “vcc” then {SALESTABLE.DELIVERYNAME} else {CUSTTABLE.MGSITRACKCHEPGLID} </pre>

View Answer   |  July 28, 2009  5:14 PM
Crystal Reports

Tables in DB2 z/OS
Your question is not very specific, and I do not know what you mean by the “default tables”. but let me try to address the topic. DB2 z/OS consists of many datasets. Each tablespace and each index space will be made up of one (or more) VSAM LINEAR datasets. The naming convention for these datasets [...]

View Answer   |  July 28, 2009  4:09 PM
DB2, DB2 Everyplace, Mainframe Datasets, Mobile development, z/OS

Selecting BDay month to match Current month
Hi, You say “SELECT” and so I assume you are using SQL. Most flavors of SQL have a function to extract the month from a date. And also a special register for CURRENT DATE. Using this MONTH function makes your query very easy… something like this … SELECT column1, column2, …, birthdate FROM your_table WHERE [...]

View Answer   |  July 28, 2009  3:59 PM
Crystal Reports

Oracle 6i Log in – User-name & Password
Oracle comes with 2 system admin userids; SYS & SYSTEM. At install time, the passwords are MANAGER & CHANGEONINSTALL. The “sample” userid of SCOTT (password TIGER) also has system admin privileges and should either be locked down or the overly powerful authorizations revoked. In addition, individual userids need to be established and authorizations granted to [...]

View Answer   |  July 28, 2009  2:27 PM
Database Management Systems, Oracle 6i

When I ran a SQL thru JCL and using DSNTIAUL/DSNTIB81 using PARMS(SQL), what kind of locks it puts on table in SELECT statement?
Any SELECT statement should only acquire SHARE locks (non-exclusive). Another application should be able to read right thru them. Ensure that you are not forcing RR (repeatable read) isolation.

View Answer   |  July 27, 2009  8:07 PM
DB2

Crystal Reports 2008 & viewer 2008
I do not believe that you can with just the viewer. From my understanding this option is only available if you have the enterprise edition.

View Answer   |  July 24, 2009  3:19 PM
Crystal Reports 2008, Crystal Reports Viewer

Find and Replace in subreport Crystal Reports
A little more detail may be needed. I just tried a find in a subreport and had no issue. Where are you trying to use it in the subreport?

View Answer   |  July 22, 2009  10:41 PM
Crystal Reports 8.5, Find and Replace, Subreports

how to block update command when using STRSQL ( db2/400)?
First do: Display Object Description (DSPOBJD) Type choices, press Enter. Object . . . . . . . . . . . . . > *ALL Name, generic*, *ALLUSR… Library . . . . . . . . . . . > YOURLIB Name, *LIBL, *USRLIBL… Object type . . . . . . . [...]

View Answer   |  July 20, 2009  9:56 PM
AS/400, AS/400 DB2, DB2, STRSQL

Inserting Subreport Problem
You can insert the subreport, but Crystal Reports will close the subreports that are currently in Preview mode. This has no permanent affect on anything, it is temporary. You can re-open the subreports in Preview mode after you insert the new subreport.

View Answer   |  July 19, 2009  6:02 PM
Crystal Reports, Crystal Reports Subreport

Crystal reports formula – equal or less than 60 days
Okay, so you place in the selection formula <pre> {TRXPOL.PreAuthEndDate} in currentdate to Currentdate + 60 </pre> This will pull all records with an expirationEndDate between the date you are running the report and 60 days after the date you run it. If you want to pull all records, but list them as you have [...]

View Answer   |  July 17, 2009  8:30 PM
Crystal Reports, Crystal Reports formulas, Crystal Reports XI

UTILIZING ECM ADAPTER 607 FOR OUTBOUND EDI 880 VIA BPCS
I am using BPCS 6.0.04- most likely your version is similar. TPEC,TBHB,TBSB, and TBLB, all keyed on GUID number. Select TPEC = ‘ECM607′ + PESTS = ’0′ +PEDWN = ‘EDI’ , Select TBHB BHICN = ‘ ‘ , Select TBSB BSICN = ‘ ‘ , Select TBLB BLICN = ‘ ‘.

View Answer   |  July 16, 2009  3:29 PM
AS/400, BPCS 6.0.02, EC, ECM, EDI, EXTOL

Crystal New Connection
Could be a bug or a bad connection. Have you tried reinstalling crystal reports? Yes, but still not able to create a new connection to the database.

View Answer   |  July 15, 2009  10:40 AM
Crystal Reports, Crystal Reports error messages, Crystal Reports XI

Field in crystal reports duplicating lines from quote
Well, obviously the View creates those extra line items because you have several notations per quote. You say that you want to suppress those extra line entries. Does this mean that you are not interrested in those extra notes at all? If so, you can modify QUOTE_Binary_to_notes: <pre>SELECT TYPE, n.OWNER_ID , CONVERT(varchar(8000), CONVERT(binary(8000), NOTE)) AS [...]

View Answer   |  July 15, 2009  1:00 AM
Crystal Reports, Crystal Reports XI, SQL Server 2000, Visual Manufacturing, Windows XP

Connection of Crystal Report 2008 with VB6.
You need to purchase <a href=”http://www.sap.com/solutions/sapbusinessobjects/sme/reporting/visualstudio/index.epx”>Crystal Reports for Visual Studio .NET</a> or Crystal Reports Developer Advantage licenses.

View Answer   |  July 14, 2009  12:11 AM
Crystal Reports 2008 controls, Database connectivity, SQL Server 2000, VB 6, Visual Basic 6

CRYSTAL REPORTS QUESTION REQUIRING , GROUPING, SUMMARIZING AND SUPRESSING ?
I’m not sure if there was a question there? If I follow correctly I think you are saying you do not want to display date fields on the report, but you want to group and/or sort based on the date fields? If that is correct, then there are no requirements stating that you have to [...]

View Answer   |  July 13, 2009  4:58 PM
Crystal Reports, Grouping, SUMMARIZING AND SUPRESSING DATA

Showing a substiute value in a report if conditions are met – Access
Use expression instead of field. For example, <pre>issued: IIf([Issue Date] Is Not Null;’ISSUED’)</pre>

View Answer   |  July 12, 2009  3:52 PM
Access 2003, Microsoft Access, Reports

security privilege
Each username has a different privelage level. Contact your I.T. administrator to ensure you have the priveleges required for this action. Hope this helps! -Schmidtw

View Answer   |  July 10, 2009  6:05 PM
Crystal Reports error messages, Crystal Reports XI