Login or Register to Ask a Question and Join Our Community


Shell Programming and Scripting

Minute(4) issue in teradata

Login to Discuss or Reply to this Discussion in Our Community

 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting Minute(4) issue in teradata
# 1  
Old 07-11-2018
Minute(4) issue in teradata
I have values below for which diff field is giving error like
"invalid time interval" in teradata

Might be it is not doing calculation anymore after exceeding minute(4) value

Code:
END_TS 2/2/2018 08:50:49.000000
START_TS 1/5/2018 17:30:02.000000
SLA_TIME 23:59:59.000000


Code:
select (cast((cast(JRDC.END_TS as timestamp) -Cast(CAST( cast(JRDC.START_TS as DATE FORMAT 'YY/MM/DD') AS  TIMESTAMP(0)) + 
(SLA_TIME - TIME '00:00:00.000000' HOUR TO SECOND) as timestamp) minute(4)) +  CAST(1 AS interval minute) as decimal )) -1 as DIFF
from base_tbl.xyz

Last edited by rbatte1; 07-11-2018 at 01:01 PM.. Reason: Removed Bold for whole code block
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Connection with Teradata through shell Script

Hi All, As we are using SQLPLUS command to connect Oracle Database in unix: Like below syntax: sqlplus username/password@dbname << EOI SET HEADING OFF SPOOL MAX_DATE_VAL.txt select max(LAST_UPDT_DATE) from source_defect; SPOOL OFF here the result is stored in... (0 Replies)
Discussion started by: Shilpi Gupta
0 Replies

2. Shell Programming and Scripting

Teradata fastexport in ksh

Hi, I am trying to use Teradata fastexport in ksh, but getting error as below temp1.ksh: line 7: syntax error at line 10: `newline' unexpected below is my code: #!/bin/ksh LOGON_STR="TDDB/user,paswd;" DATAFILE=/path/a.lst; DEBUG=0 >$DATAFILE fexp > /dev/null... (3 Replies)
Discussion started by: usrrenny
3 Replies

3. UNIX and Linux Applications

Using BTEQ with perl to Teradata

Has anyone used either bteq or mload for inserting into a Teradata Database via perl. We're running Red Hat Enterprise 5.7. I've gotten the DBD::ODBC drivers installed and running. I installed the Teradata ICU, TeraGSS and ODBC pkgs. We are using perl to insert data across the network into... (1 Reply)
Discussion started by: islanderman
1 Replies

4. Shell Programming and Scripting

Execute teradata queries from a file

In a .txt file i have a set of teradata queries which i need to execute and capture result for all queries.Is there any way to run teradata queries from a file? (1 Reply)
Discussion started by: katakamvivek
1 Replies

5. Shell Programming and Scripting

Teradata connectivity through UNIX by use bteq

Hi, I want a script for connecting teradata to load the file to teradata table. Can you please help me out. Thanks in advance. (1 Reply)
Discussion started by: victory
1 Replies

6. Shell Programming and Scripting

Fast export in UNIX using Teradata creating issue

Hi All, I am trying to export a file using Fast Export (Teradata) in UNIX. The desired output length is 550 bytes, but the output file is creating string till 75 characters. How to get the full length file? .LOGON .EXPORT file=export.txt; SELECT CAST(('' || (CAST('UD ' AS CHAR(3))) || ... (2 Replies)
Discussion started by: unankix
2 Replies

7. Shell Programming and Scripting

Take minute per minute from a log awk

Hi, I've been trying to develop a script that performs the parsing of a log every 1 minute and then generating some statistics. I'm fairly new to programming and this is why I come to ask if I can lend a hand. this is my log: xxxx 16/04/2012 17:00:52 - xxxx714 - E234 - Time= 119 ms.... (8 Replies)
Discussion started by: jockx
8 Replies

8. Programming

Connect To Teradata

How do i connect from C program to teradata Database? The C program is being executed from a Unix script, AIX. I am calling a C program from a Unix shell script and the C Program executes some SQLs on Teradata Database. (3 Replies)
Discussion started by: yschd
3 Replies

9. Programming

compile a program in C with teradata sentences using cc

hi, I want to compile a program in C. It have a multiple calls to teradata. I have no idea how to compile in Aix. The compiler that I should be use is cc. I tried cc -G -KPIC tdsfbd0358.c this generates a tdsfbd0358.i and after I have no Idea what I have to make, a link? how?... (3 Replies)
Discussion started by: kajum
3 Replies

10. Programming

Unix - teradata

I am trying execute a sql file from the script and the sql file has the following code snippet, which throws out the error given below FOR C_FINELINE_LP AS CURSOR C_SLS FOR SELECT * FROM WM_UTIL.FLT_DEP WHERE LOAD_IND = 'N' DO ..... ..... .... END FOR; FOR C_FLTSLS_STR_LP AS... (0 Replies)
Discussion started by: yschd
0 Replies
Login or Register to Ask a Question

LEARN ABOUT OSF1

sleep

sleep(1)						      General Commands Manual							  sleep(1)

NAME

       sleep - Suspends execution for at least the specified time

SYNOPSIS

       sleep seconds

STANDARDS

       Interfaces documented on this reference page conform to industry standards as follows:

       sleep:  XCU5.0

       Refer to the standards(5) reference page for more information about industry standards and associated tags.

OPTIONS

       None

OPERANDS

       Non-negative integer specifying the number of seconds for which execution is to be suspended.

DESCRIPTION

       The  sleep  command suspends execution of a process for at least the interval specified by seconds, which can range from 0 to 2,147,483,647
       seconds.  Depending on system activity, the actual time of suspension may be longer.  See the sleep(3) reference page.

       [Tru64 UNIX]  seconds can be entered as a non-negative decimal, octal, or hexadecimal value.

NOTES

       If sleep receives a SIGALARM signal before process execution has resumed, sleep takes one of the  following  actions:  Terminates  normally
       with a 0 (zero) exit status.  (See the sleep(3) reference page for more information.)  Ignores the signal Performs default processing

EXIT STATUS

       The  following  exit  values  are  returned: Execution was successfully suspended for at least the requested time, or a SIGALARM signal was
       received.  An error occurred.

EXAMPLES

       To display a message at 4-minute intervals for 20 minutes, create a shell script called remind containing the following:

	      for i do sleep 240; echo $i sleep 240; echo $i sleep 240; echo $i sleep 240; echo $i sleep 240; echo $i done

	      To display the message Try calling NHK at 4-minute intervals, enter: remind 'Try calling NHK' To run a command at regular intervals,
	      create a shell script containing the following:

	      while true do
		      date
		      sleep 60 done

	      This  displays  the date and time once a minute.	To execute a command after a specified interval, enter the following; (sleep 3600;
	      echo Time's up) &

	      This displays the message "Time's up" after one hour.

ENVIRONMENT VARIABLES

       The following environment variables affect the execution of sleep: Provides a default value for the internationalization variables that are
       unset or null. If LANG is unset or null, the corresponding value from the default locale is used.  If any of the internationalization vari-
       ables contain an invalid setting, the utility behaves as if none of the variables had been defined.  If set to a  non-empty  string  value,
       overrides  the  values of all the other internationalization variables.	Determines the locale for the interpretation of sequences of bytes
       of text data as characters (for example, single-byte as opposed to multibyte characters in arguments).  Determines the locale for the  for-
       mat  and  contents  of  diagnostic messages written to standard error.  Determines the location of message catalogues for the processing of
       LC_MESSAGES.

SEE ALSO

       Commands:  wait(1)

       Functions:  alarm(3), pause(3), sigaction(2), sleep(3)

       Standards:  standards(5)

																	  sleep(1)