DSXchange

I would go with a script (Unless its a different database and you don't have a dblink) select t1.*, t2.* from $TableA t1 left join $TableB t2 on t1.$PK1=t2.$PK2 where t2.$PK2 is null you can use full outer join if required. If Keys vary then select t1.*, t2.* from $TableA t1 left join $TableB t2 on ...

This is the output resulting from the sql query. Field1...... Field2......... Field3.............. Field4.... Field5.... -4927275313 Not Applicable 2008-05-06 09:06:40 Test1 0 -4829300379 Not Applicable 2008-03-25 07:38:49 Test2 0 -4813747248 Not Applicable 2008-03-17 10:51:17 Test3 0 -4702305701 No...

Any tips that I could hunt on?

If you were to use a "LIST" instead of a "SELECT" the previous advice would have helped and you would get more assistance on any other errors. What does "LIST HashOther" or "LIST DICT HashOther" produce? I had both LIST and SELECT above... I am repeating them...

I made some study and found that we can change the width of all fields to a predetermined value by using CONNECT localuv .w *,<width> But even when I do that still the truncation/folding occurs [There is no other option allowed ie. to allow for continous display of the row] Right now I see that the ...

you have to contact network administrator or let your datastage admin know about it.

I guess that would be a valid date, so you would need to have a special condition (ie. ignore 0000-00-00) apart from checking whether its a date. As to know whether it is a date or not, there are date functions available, you could apply your own logic on them to know whether its a valid date or not.

Try to trim out the double quotes first and then use comma as the field separator

we might have to remove the -s option and forward the output to a file, then may be grep and indicate error based on it

sqlplus $UserId/$Password@$OracleDb <<-EOF > $File
DELETE FROM <your staging table>;
EOF

Create a job control using the following- You can call this in before sub-routine UnixCmd = ScriptName : Agr1 :" ": Agr2 :" ": Agr3 Call DSU.ExecSH(UnixCmd, ErrCode) In the Unix Script :ScriptName call sqlplus sqlplus -s $UserId/$Password@$OracleDb <<-EOF DELETE FROM <your stagin...

The data doesn't have new line characters. I have checked it.

I have to do this on unix. As its not limited to just one hashed file. It has to be generic script. Which will be called by passing arguments

Hi all,

Any ideas... I have been reading here and there, but no luck with it.

Thanks

LIST DICT yourhashedfile when I do the list.. even the column names (not all) are split (comes half in one line half in other ) GET.TERM.TYPE I have used GET.TERM.TYPE and saw that the width is changing from 80 to 132. But the following are still occuring a) HashFile1 : split of fields - fields com...

Yes I do have it in seperate line as below. LOGTO <ProjectName> SET.TERM.TYPE WIDTH 132 SELECT * FROM <HashedFile>; Is there any max limit to it, as I want this to be generic and wouldn't like my process causing a limitations. Will this as well solve the splitting of the fields? I will try to look a...