DSXchange

kmsekhar

Thanks all

kmsekhar

Hi All, I have jobs names like: Server Jobs - ser_Sample1 Parallel Jobs - parl_Sample1 Sequencer - seq_Sample1 generally I am using the below commands to get the count To Count Parallel Jobs in a Project SELECT COUNT(*) FMT '60L' FROM DS_JOBS WHERE NAME LIKE 'parl_%'; To Count Server Jobs in a Proje...

kmsekhar

As suggested by Ray if the incoming data is not (Int32,Decimal) datatype then another way to check for numeric data

Code: Select all

If IsValid("int32", InputColumn) Then "Int" Else "Var"

kmsekhar

If you want to store the target oracle count in unix variable: #!/bin/sh REC_COUNT=`sqlplus -silent user/password@instance <<END set pagesize 0 feedback off verify off heading off echo off select count(*) from tgttable; exit; END` if [ -z "$REC_COUNT" ]; then echo "No rows returned fr...

kmsekhar

I think you can perform the validation before loading into Target Oracle: 1.Get the count of source file $ awk '{n++} END {print n}' SrcFile.txt 2.Get The count of Control file 3.Is there any mismatch in count then pass the exit code as non-zero in the script. so that you can abort the job and send ...

kmsekhar

@FM --> Field mark: CHAR(254). Same as @AM.

kmsekhar

Thanks Ray, Now able to generate output as desired

Code: Select all

temp = Arg1

Ans = Arg1

if Arg2<>Arg1 then

LOOP

UNTIL temp > Arg2 DO

Ans = Ans :"|": temp

temp = temp+1


 REPEAT

END

kmsekhar

Satwika, You can eliminate the above rows in execute command stage by

Code: Select all

#below command will remove first 7 lines of a file

sed 1,7d 

and

# delete the last 2 lines of a file
sed 'N;$!P;$!D;$d'

kmsekhar

Hi, DS: 8.0.1v, Server Job My Input File is: C|CB|OTH|0001000|0001005 C|CB|OTH|0022222|0022222 C|CB|OTH|0000001|0000003 My desired output should be: 0001000 0001001 0001002 0001003 0001004 0001005 0022222 0000001 0000002 0000003 I have achieved using script: BEGIN { FS = "|" OFS = "\n...

kmsekhar

try to use ISO-8859-1

kmsekhar

Thanks all for you suggestions... We are planning to go for Cloning...

kmsekhar

Hi, We are planning to migrate existing UNIX AIX 5.3 Server to new UNIX AIX 5.3 Server.. Same hardware configuration is used in the new server ie.,as same as old server.. Could you please advise me.. for new scenario which one is best option.. UNIX Cloning -- According to me its the fastest and safe...

kmsekhar

try exact search for "Some users will not have access to this schema". or else check viewtopic.php?p=313342

kmsekhar

It seems to be issue is not related to lookup reference's.. we can pass N no of reference's...

Possible error might be in DB2 database end.. Check any of the reference table having problem. May the table is unavailable for any reason......[/img]

kmsekhar

few more points.. Usually In a transformer its better to handle all the nullable columns before we do any arthimatic calculations (ie., ADD,DIV,SUB,MUL,CONCAT,SUBSTRING etc...)
We have options to handle null using any of the functions

NULLToValue
IsNULL
.......
.......

DSXchange

Search found 57 matches

Count Jobs in a project (Parallel, Server, Sequencer)

Re: What is @FM

Re: How to eliminate summary part :

Increment Values based on two columns (Looping)

Can we do Datastage Cloning?