Sponsored Content
Top Forums Shell Programming and Scripting How to check the datatypes of the columns are same through shell scripting? Post 302995291 by rbatte1 on Tuesday 4th of April 2017 09:10:36 AM
Old 04-04-2017
You can normally define a few things to help you, such as unique constraints and defining the column as not accepting nulls.

It then depends on your loader if it pushes in the records it can and reports the anomalies, or if it just fails altogether at the start or with partial data loaded.



Robin
 

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
HTML::FormFu::Constraint::DBIC::Unique(3pm)		User Contributed Perl Documentation	       HTML::FormFu::Constraint::DBIC::Unique(3pm)

NAME
HTML::FormFu::Constraint::DBIC::Unique - unique constraint for HTML::FormFu::Model::DBIC SYNOPSIS
$form->stash->{schema} = $dbic_schema; # DBIC schema $form->element('text') ->name('email') ->constraint('DBIC::Unique') ->resultset('User') ; $form->stash->{context} = $c; # Catalyst context $form->element('text') ->name('email') ->constraint('DBIC::Unique') ->model('DBIC::User') ; $form->element('text') ->name('user') ->constraint('DBIC::Unique') ->model('DBIC') ->resultset('User') ; or in a config file: --- elements: - type: text name: email constraints: - Required - type: DBIC::Unique model: DBIC::User - type: text name: user constraints: - Required - type: DBIC::Unique model: DBIC::User column: username DESCRIPTION
Checks if the input value exists in a DBIC ResultSet. METHODS
model Arguments: $string # a Catalyst model name like 'DBIC::User' resultset Arguments: $string # a DBIC resultset name like 'User' self_stash_key reference to a key in the form stash. if this key exists, the constraint will check if the id matches the one of this element, so that you can use your own name. id_field Use this key to define reference field which consist of primary key of resultset. If the field exists (and $self_stash_key not defined), the constraint will check if the id matches the primary key of row object: --- elements: - type: Hidden name: id constraints: - Required - type: Text name: value label: Value constraints: - Required - type: DBIC::Unique resultset: ControlledVocab id_field: id others Use this key to manage unique compound database keys which consist of more than one column. For example, if a database key consists of 'category' and 'value', use a config file such as this: --- elements: - type: Text name: category label: Category constraints: - Required - type: Text name: value label: Value constraints: - Required - type: DBIC::Unique resultset: ControlledVocab others: category method_name Name of a method which will be called on the resultset. The method is passed two argument; the value of the field, and the primary key value (usually `id`) of the record in the form stash (as defined by self_stash_key). An example config might be: --- elements: - type: text name: user constraints: - Required - type: DBIC::Unique model: DBIC::User method_name: is_username_available SEE ALSO Is a sub-class of, and inherits methods from HTML::FormFu::Constraint HTML::FormFu::FormFu AUTHOR
Jonas Alves "jgda@cpan.org" LICENSE
This library is free software, you can redistribute it and/or modify it under the same terms as Perl itself. perl v5.12.4 2011-07-16 HTML::FormFu::Constraint::DBIC::Unique(3pm)
All times are GMT -4. The time now is 07:50 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy