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!

Register Log in
  • 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. PelleNo

    Load a tab-separated file

    Hello ! Is there a way to load a tabseparated file from a IBM mainframe platform ? Are there any switches in Multiload or Fastload to do the trick ? /Pelle
  2. PelleNo

    Conversion of '@' via IBM

    OK I will have my system programmer have a look at the Swedish character set implemeted. /Pelle
  3. PelleNo

    Conversion of '@' via IBM

    Thank you for your fast reply. Normally I run with the character set 'SWEDISH' wich can handle our regional characters Å,Ä,Ö.(but not @) I consulted the manuals and the character sets I find are : EBCDIC KATANAEBCDIC KANJIEBCDIC5026_0I KANJIEBCDIC5035_0I KANJIEUC_OU KANJISJIS_0S ASCII I set...
  4. PelleNo

    Conversion of '@' via IBM

    Hello ! I load a flat file extracted from Unix. I use a IBM mainframe as utility platform. The file contains emailadresses and they look OK when I look at the file in the IBM. The '@' is represented by hex 'EC' (EBCDIC). When I load the file into Teradata the '@' will show up as 'í' in my...
  5. PelleNo

    Arithmetics on Timestamp

    I would like to calculate the difference between 2 fields, both declared as Timestamp(6). A simple subtraction is not allowed can I cast or format in any way to get through with this !? Best regards PelleNo

Part and Inventory Search

Back
Top