DSXchange

prabu

this_is_venki wrote:Hi,
I want to get trasnferred multiple zip files from remote location.
So I am calling a shell script which is having certain unix commands to execute the same. how can it be done in Datastage7.5?

Or is there any other efiecient way to do it?

Please use FTP satge, if you mean transfer as 'Ftp'ing

prabu

Do a 'UNION ALL' between Table 1 and Table 2 You also should undertand that UNION ALL will preserve the duplicates, say value 'A' is available in both datasets, your generated result set will have A A UNION will suppress duplicates UNION ALL will make use of parallelism but UNION cannot.

prabu

rodre wrote:Thank you all for the response. :D
One question:
What is the syntax for the pointer SETFILE command?

Code: Select all

HELP SETFILE

prabu

ArndW wrote:What happens if you escape it as in \# ? ...

you will hit bulls eye

, i have checked it , it solves the problem

prabu

Hi, I am doing a lookup, both sorce and lookup(hash file) has matching records. but the records are not hooking up, and no data is coming from lookup. i deleted the hash file and recreated it. can some let me what's the prob. Thanks in advance. i like your terminology hooking up :lol: . 1)check if ...

prabu

I get the following error when I RUN the job "Error setting up internal communications (fifo \\.\pipe\prjDev-RT_SC2-CopyOftest1)". Can anyone please let me know what would be the cause ? Hi maheshalways, 1)check if you have enough disk space 2)stop and start datastage services, its a wind...

prabu

Hi, I face a very exceptional problem , Job get finished and the log shows the data is loaded in the table , where as no data is loaded in the table . Any how i have done some work around , but can any body help me to understand what had actually happened . regards HemantK did you try executing sho...

prabu

Hi, I face a very exceptional problem , Job get finished and the log shows the data is loaded in the table , where as no data is loaded in the table . Any how i have done some work around , but can any body help me to understand what had actually happened . regards HemantK did you try executing sho...

prabu

Hi All, I am using an environment variable (Oracle login password) as a job parameter. I can run the job successfully using it, but when i tri to do "view data" i can't and get this error... Error executing View Data command: Bad dboption list. Failed on Expected value for property "...

prabu

Is it better to sort before or after processing the data (eg. transformer) ? (I mean for better performance) Psriva, use sort finally, if the intermendiate stages doesn't expect sorted data. example:- remove duplicate stage expects your data to be sorted. Ideally, dont sort at all, if you dont want...

prabu

vsi wrote:I used
Code: Select all
id <username>
command and i get only one group, but when i use
Code: Select all
groups <username>
. I get three groups the same user belongs to.

Why is that?

please try

Code: Select all

 id -a username

i prescribe google freely to you
use me pls

prabu

please try the following code. i believe ren is not a valid DOS command , but mv works. All the best!! * courtesy DSGuru * The intention of this site it to give you a fishing rod, worm * and fishing boat, somtimes * it cannot cook the fish remotely :lol: :lol: FileName = Arg1 CurrDate = Oconv(Date()...

prabu

ray.wurlod wrote:You can't believe me, believe me! ...

"i beleive you! if you beleive me!!", completing the soliloquy

Philosophical Observation
One can always say "believe" if one cannot say "trust"

prabu

vsi wrote:how do we know, what is the group of a particular file/directory?

Code: Select all

groups username - groups the current user belong to 
chgrp  - to change his group

Also check out getacl and setacl

usally you use

Code: Select all

cp -p - preserve permissions

prabu

Read Input For every input record Lookup DB2 Table for the value If Value is found Write to Output Else Compute the random value Write to Db2 Lookup Table Write to Output end If end For Probably in Server job we can do this using Hash files, but in Parallel job I am not able to implement this using...

DSXchange

Search found 142 matches

Re: Call a shell script in datastage job

Re: look up issue

Re: Error when running Parallel Job

Re: data load problem

Re: data load problem

Re: Job Parameter : Environment variable as Password

Re: Sort stage

Re: unix question

Re: Simultaneous Read and Write to a DB2 Table