DSXchange

You have two non-matches: (1) Those, which are in the seq-File and not in Oracle (2) Those, which are in Oracle and not in seq One way is to read the the key of the seq-file completly into oracle and make there two minus. (1) minus (2) and (2) minus (1) I need the rows that are in the Oracle table ...

I currently have a sequential file that has 12,669,842 records and an Oracle table with roughly the same number of rows. What is the best way to get non-matched rows from the Oracle table? I've thought about just creating two hashed files and using my sequential file/hashed file as the reference str...

As an alternative (but probably not a preferred one), you can always use Rank in your select statement and get everything where Rank > 1

Works like a charm!

CmdString=("cat ":TEMPDIR:ExtractCriterionJob:CriteriaFileNm)
MsgTxt=CmdString
Call DSLogInfo(MsgTxt, DSJobName)

CALL DSExecute("UNIX", CmdString, CriteriaValues, ReturnCode)


Thanks!!

How do you list them. I've tried several different approaches. I've listed them like you would in a ksh: CALL DSExecute("UNIX", "cat $TEMPDIR$ExtractCriteriaJob$CriteriaFileNm", CriterionValues, ReturnCode) I've treated them like normal DS params: CALL DSExecute("UNIX",...

Can you pass variable file paths and file names into your unix cat? I have parameters set for those values since this file will be moved to different environments.

That's what I thought. Thanks for clearing that up!!!

[quote="chulett"]Helps to make proper use of the 'code' tags so your formatting is preserved. Where, exactly, are you getting this "status of 1"? :? I'm out putting the status in the message log with "MsgTxt = "Rslt = ":Status" and it's giving me a status of 1...

I am creating a sub routine to read in one parameter from a sequential file. I keep getting a status of 1 which is "An end-of-file" was encoutered. I have this set up to check the return code and flag it for any rc that's not 0. What is causing this error and how do I fix it. here is the j...