Sponsored Content
Top Forums Shell Programming and Scripting How to check the datatypes of the columns are same through shell scripting? Post 302995286 by jim mcnamara on Tuesday 4th of April 2017 08:35:30 AM
Old 04-04-2017
Do you mean as an example:
You expect a date datatype. Does the date have to be valid?

Or do you simply want to make sure no number datatypes have problems?

To be honest I have worked with databases for a VERY long time, and the databases have always caught datatype mismatches. The requirement sounds more like really uniformed management decision.

In any case, please give us some simple examples of what you need to check.
 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

difference between AIX shell scripting and Unix shell scripting.

please give the difference between AIX shell scripting and Unix shell scripting. (2 Replies)
Discussion started by: haroonec
2 Replies

2. UNIX for Dummies Questions & Answers

How to check process/cpu utilisation thru unix shell scripting

Dear Champs, Can anybody help me out to write a shell script , which will check whether the process is running , if running then divide the process into 2 so that next var it can take process parallel . Let ps -ef | grep a.sh => shows running note a.sh will take a process of next... (0 Replies)
Discussion started by: manas_ranjan
0 Replies

3. Solaris

How to check the file existence using shell scripting in Solaris-10

Hi, I have a script which will check the fiel existence, the lines are as below if !(test -d ./data) then mkdir data fi In the first line error occurs as below generatelicense.sh: syntax error at line 2: `!' unexpected Where as this script works fine in linux OS. How to solve... (2 Replies)
Discussion started by: krevathi1912
2 Replies

4. Shell Programming and Scripting

New to Shell scripting: Can you check it?

I am trying to write a script to get all the html files under a source directory and and for each html file, run a program with html file as an argument. This program generates an output which I need to save as htmlfilename.txt ( right now i was trying to print it on the command line) ... (11 Replies)
Discussion started by: sapient
11 Replies

5. Shell Programming and Scripting

Scripting columns

I've got the following data in a file - basically hundred of passes. Pass Id : PASSID1 Pass Name : 7 day pass 10 Gb Pass Group : uk Short Name : pmbbrh2 type : restrict Validity ... (7 Replies)
Discussion started by: jeffersno1
7 Replies

6. Shell Programming and Scripting

C shell scripting, check if link exists on remote servers

Hi, I'm new to C Shell programming. I'm trying to check if a sym link exists on remote server if not send email. I'm not having much luck. Can anyone help? Here is what I have written but it doesn't work. It tells me that my variable was not defined. Here is part of the script, the second... (0 Replies)
Discussion started by: CDi
0 Replies

7. Shell Programming and Scripting

Transposing rows and columns (pivoting) using shell scripting

Here is the contents of an input file. A,1,2,3,4 10,aaa,bbb,ccc,ddd 11,eee,fff,ggg,hhh 12,iii,jjj,lll,mmm 13,nnn,ooo,ppp I wanted the output to be A 10 1 aaa 10 2 bbb 10 3 ccc 10 4 ddd 11 1 eee 11 2 fff 11 3 ggg 11 4 hhh ..... and so on How to do it in ksh... (9 Replies)
Discussion started by: ksatish89
9 Replies

8. Shell Programming and Scripting

Validating a datafile with the datatypes

I have two input files 1)datafile 2)metadata file. I have a metadata file like: field1datatypeformat1number2string3dateyy-mm-dd I have a data file like: 1234abc12-8-16 xyz234512-9-163456acd14-08-12 In the first row there is no correction as everything is inline with the metadata.... (3 Replies)
Discussion started by: bikky6
3 Replies

9. Shell Programming and Scripting

Shell scripting - need to arrange the columns from multiple file into a single file

Hi friends please help me on below, i have 5 files like below file1 is x 10 y 20 z 15 file2 is x 100 z 245 file3 is y 78 z 23 file4 is x 100 (3 Replies)
Discussion started by: siva kumar
3 Replies

10. Shell Programming and Scripting

To check if the JAVA Program is successfully executed in sh shell scripting

Hi , I have written a shell script to call a java program say load_id.sh .This sh script indeed is executed implicitly in other sh script which calls 2 more sh scripts one by one. I need to check if the load_id.sh (which calls java program) is executed successfully only then continue with... (1 Reply)
Discussion started by: preema
1 Replies
MPI_Type_create_f90_integer(3)					     Open MPI					    MPI_Type_create_f90_integer(3)

NAME
MPI_Type_create_f90_integer - Returns a bounded MPI integer datatype SYNTAX
C Syntax #include <mpi.h> int MPI_Type_create_f90_integer(int r, MPI_Datatype *newtype) Fortran Syntax INCLUDE 'mpif.h' MPI_TYPE_CREATE_F90_INTEGER (R, NEWTYPE, IERROR) INTEGER R, NEWTYPE, IERROR C++ Syntax #include <mpi.h> static MPI::Datatype MPI::Datatype::Create_f90_integer(int r) INPUT PARAMETER
r Precision, in decimal digits (integer). OUTPUT PARAMETERS
newtype New data type (handle). IERROR Fortran only: Error status (integer). DESCRIPTION
This function provides a way to declare KIND-parameterized INTEGER MPI datatypes. The argument is interpreted in a similar fashion to the F90 function SELECTED_INT_KIND: r must be a scalar integer, and represents the desired level of numerical precision, in decimal digits. NOTES
It is erroneous to supply a value for r not supported by the compiler. The Fortran function SELECTED_INT_KIND maps a large number of r values to a much smaller number of KIND parameters supported by the com- piler. KIND parameters are not specified by the language and are not portable. From the point of view of the language, variables of the same base type and KIND parameter are equivalent, even if their KIND parameters were generated by different r arguments to SELECTED_INT_KIND. However, to help facilitate interoperability in a heterogeneous environment, equivalency is more strictly defined for datatypes returned by MPI_Type_create_f90_integer. Two MPI datatypes, each generated by this function, will match if and only if they have identical values for r. The interaction between the datatypes returned by this function and the external32 data representation - used by MPI_Pack_external, MPI_Unpack_external and many MPI_File functions - is subtle. The external32 representation of returned datatypes is as follows. if (r > 38): external32 size = n/a (undefined) else if (r > 18): external32 size = 16 else if (r > 9): external32 size = 8 else if (r > 4): external32 size = 4 else if (r > 2): external32 size = 2 else: external32 size = 1 If the external32 representation of a datatype is undefined, so are the results of using that datatype in operations that require the external32 format. Care should be taken not to use incompatible datatypes indirectly, e.g., as part of another datatype or through a dupli- cated datatype, in these functions. If a variable is declared specifying a nondefault KIND value that was not obtained with SELECTED_INT_KIND (i.e., r is unknown), the only way to obtain a matching MPI datatype is to use the functions MPI_Sizeof and MPI_Type_match_size. ERRORS
Almost all MPI routines return an error value; C routines as the value of the function and Fortran routines in the last argument. C++ func- tions do not return errors. If the default error handler is set to MPI::ERRORS_THROW_EXCEPTIONS, then on error the C++ exception mechanism will be used to throw an MPI:Exception object. Before the error value is returned, the current MPI error handler is called. By default, this error handler aborts the MPI job, except for I/O function errors. The error handler may be changed with MPI_Comm_set_errhandler; the predefined error handler MPI_ERRORS_RETURN may be used to cause error values to be returned. Note that MPI does not guarantee that an MPI program can continue past an error. See the MPI man page for a full list of MPI error codes. SEE ALSO
MPI_Pack_external MPI_Sizeof MPI_Type_match_size MPI_Unpack_external SELECTED_INT_KIND 1.4.5 Feb 10, 2012 MPI_Type_create_f90_integer(3)
All times are GMT -4. The time now is 10:24 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy