DSXchange

Hi, I am getting an error "value larger than specified precision allowed for this column" while loading the table, I dont know the exact column for this error . but i have a column in table whose data type is number 9(5) and for this field i am getting value from source as 12345.98000. Can...

kcbland wrote:Look at this:
viewtopic.php?t=85578

It's a shell script that runs dsjob. You should be able to get the idea how some of us are using it.

Thanks Kcbland.

ray.wurlod wrote:Type dsjob alone (no parameters) to get the top-level syntax.

Type dsjob -run (no further parameters) to get the syntax for running jobs.

Cross-reference what you learn here back to the manual.

Thanks Ray.

kcbland wrote:You mean the command line program dsjob? It's fully documented in your DS manuals under the Start menu as well as having help just by typing in dsjob.

Thanks for the reply kcbland. i have seen the documentation but i couldnt figure our what are the operands for DSJOB?

Sorry, it is not attributes. i was referring to operands of DSJOB

Hi,
I was just wondering what are the attributes for DSJOB. I know that there are options,parameters for DSJOB but not sure of attributes. Can anyone please confirm it?

Thanks,

Hi All,
Thanks for your suggestion.

To make it clear WHY they advised thus, a hashed file can only be looked up using an exact match on its key column(s). You are trying to do a "reverse lookup", which is not supported by the Hashed File stage (for the reason above). You could use a UV stage to perform a reverse lookup agai...

kcbland wrote:Build another hashed file with col_code as the primary key and ID as the attribute.

But if i have another hash file, how can i match with the col_code with the source column name. Can please come in detail.

Thanks

Your original question stated you needed to align a source column named A to a specific lookup for 3 known values. I now do not understand your followup question because it doesn't correlate to your original. sorry for confusion. Let me come again.. I have a source file with column names A,B,C. And...

kcbland wrote:Sounds like you need multiple reference links to the same hashed file, each one with different literal values in the key expression.

I have 6 hash files each with 14 columns to match. is there any different logic.

Thanks

Hi, I am getting 3 columns named A,B,C from Source and i have to do a lookup to a hashed file which has 2 columns named col_ID,col_code where col_ID has values 20,30,40 and col_code has values A,B,C. I have to match such that if the source column name is 'A' and Hashcolumn Col_code value is 'A' then...

I have 4 jobs which run in parallel in Sequence. I want to be notified through email ONLY if any one of the job aborts. How do I do that??? I understand I have to use Notification Activity stage but can somebody throw some light on the design aspects like how many Notification stage I should use an...

You... could. It (the database work) would run much slower, however, so keep that in mind. All that really buys you that I can see is the fact that your hashed file would be in sync with your database in the event of an abort, and it changes your restart/recovery process. I prefer to not do it that...

chulett wrote:There's no reason to 'commit for each insert'.

Well, i thought we will be able to update the hash file with the current data if we commit for each record in the target table.