DSXchange

yes,

ths sysout will be read by datastage.

assume that i saved script in directory /home/myscripts

assume that script name is: "Read5Lines" with filename as argument.

in filter command what i need to write?



thanks
sunshine

Hi,

I have a Sequential Stage. In the filter command i need to call a scirpt with an argument. its unix script.


in which Unix directory i need to store the script?

not sure whether this will work or not.


let me know if you have any questions?


thanks
sunshine

Can we pass Fieldname as Parameter at runtime, within DRS Stage?

when i tried to use #$FIELD_NAME# for a field,in DRS Stage, its saying fieldname must start with character..


Thanks

Hi,

Other than Director,how can i view the log file?

i browsed the site and came to know that RT_LOGnnn has log info.
can you be more specific,where exactly i can view the log gile and also steps to view the log.

appreciate ur help..

Thanks
sunshine

sorry guys,

i was misunderstood.

Thank you for all,for spending so much time on this topic.

Thhnks once again

sunshine

sill i haven't got solution. assume that i need to execute multiple commands eg: cp a1 a2 cp a2 a3 cp a3 a4 these i need to execute before executing job. if it is only one command, just in can write in Before Subroutine . but in this case,what i need to do? Lookinf forward for ur reply thanks sunshine

ok chulett,

assume that u want to use multiple proper commands, inside filtercommand..

for eg:
cat ...
sep ....
head ....

in this case, what should i do?

my question is,should i need to write in .txt file and use the filepath inside FilterCommand or something else...

Thnks
sunshine

lets say i need to execute some commands in FilterCommand. for eg: tar cf mytar.tar A.txt B.txt C.txt mv sample.html public_html chmod go-rwx biglist my question is: should i write all these commands in a .txt file and give the path of this .txt file in Filter Command? or some other solution? Thnks ...

[quote="ray.wurlod"]Use [b]head [/b][b]tail [/b]and [b]wc -l [/b]to strip off the header and trailer lines. ...[/quote]

where i can use this head and tail

can you explain me detail

Thanks
sunshine

Skip header and tail while reading from a flat file. source.txt eg: CountryName|Capital USA|Washington UK|London Austria|Vienna Generated on: 04/04/2006 I need to skip the header and tail while reading. resulted output is USA|Washington UK|London Austria|Vienna i searched in DSX, someone told to use...

hi,

i need some information/procedure for migrating datastage jobs from version 3.0 to 7.5. please guide me how to complete this process.

in unix os.


thanks,
sunshine.

Hi, I need to execute Stored Procedure on a Table, in Data Stage scenario is: OCI ---> Transformer-->ODBC Stage Here i am copying data from OCI Stage(EMP) to ODBC Stage( EMP_NEW) in the mean time, I need to execute a StoredProcedure on table "EMP_NEW" I already created storedprocedure on T...

what happens when size of a Hash file increases?

what happens when size of a Hash file increases?

Hi,

What happens to a Hash file,when size is increased?

lets say i am transfering data from database to a Hash file.

I came to know from DSXchange forum that maximum allowable for a Hash file is 2 GB.

Can someone explain in more in detail....


Thanks

sunshine