Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. marcholmes

    data types

    I've got to produce a dataset on the IBM mainframe that can then be loaded up to an Oracle database. What are the valid formats I can use for the data? Everything I've seen so far has been CHAR. Is it not possible to use Integer (in cobol S9(9) COMP) or Decimal (S9(13)V99 COMP-3) formatted...
  2. marcholmes

    Word opening a new document

    (sorry for the delay, been on hols) The template is called Standard.dot I've successfully amended it so that the HEADER1 no longer appears when I open a document, but it still opens a blank document when I open an existing one (unless another document is already open) No macros are present in...
  3. marcholmes

    Word opening a new document

    Double click in either explorer or a desktop shortcut, or even a single click from recent documents. The intended document opens correctly, as well as a new document, "Document1", with the text "Header1" in style of Header1. Problem does not occur if Word is already open with another document...
  4. marcholmes

    Word opening a new document

    Whenever I double click on an existing document Word also opens a new document with "Header 1" in it. Why? Is it a setting, or something in the default template? How do I stop it?
  5. marcholmes

    Shared Documents

    XP Pro being used. Shared Documents folder pre-existed from build. Copied some files in there from another drive. I can change them, even though the read-only flag is ticked (if I remove it, it comes back). Yet the wife, another super-user, can only read the files, no update allowed. Why?
  6. marcholmes

    Export from Turnpike, import into Outlook

    Turnpike can only export emails in "Berkeley" (a.k.a. "Unix") format. Outlook does not recognise this format. How do I bridge the gap?
  7. marcholmes

    Use of CASE in WHERE

    It must be possible, because Teradata doesn't complain. It just doesn't return any data. Here's the code:- WHERE AIB IN (CASE WHEN EXTRACT (MONTH FROM DATE) IN (1,4,7,10) THEN '(A,B)' ELSE '(I,B)' END ) Where am I going wrong? p.s. yes, I know it can be done with ANDs...
  8. marcholmes

    Fastload a file from MVS with a S9999 field

    Sorry, should have read S99999, i.e. 12345B (looks like FFFFFC 123452 in hex) Does that make a difference? What do I put in the DEFINE statement? INTEGER would expect 4 bytes in binary.
  9. marcholmes

    Fastload a file from MVS with a S9999 field

    How do I fastload a file from MVS which contains a field which you would define in COBOL as S9999? It's not decimal, or integer.

Part and Inventory Search

Back
Top