DSXchange

ArndW wrote:Have you tried quoting?

Code: Select all

./dssearch -ljobs -matches -sub -c 'DE ACCT' -j s dpr_rs_dev>>/data/dw/rs/dev/seqfiles/tempJobsList1.txt 

...

yes, i have tried with single and double quotes as well, then also not working.

Hi All, dssearch command was not recognizing category name if we have the space in between. Example: ./dssearch -ljobs -matches -sub -c DE ACCT -j s dpr_rs_dev>>/data/dw/rs/dev/seqfiles/tempJobsList1.txt DE ACCT is the category name. If the category name is single word like ACCT then its working. Pl...

to delete the datafile and descriptor file belongs to a dataset which is in a unix server Orchadmin is a command line utility provided by datastage to research on data sets. search for the Orchadmin commadns to delete the dataset. other wise you can delete the dataset from dstaset management utilit...

do a hex or octal dump of the file data (use "od" or a similar tool). I am certain that one of those spaces is not like the others (the not-so-subtle reference is intended). We have converted these data to hex with the help of od -x, then only we posted here. From unix its given as 3 spac...

Sainath.Srinivasan wrote:Is there any filter property in the filename ?

nope

PhilHibbs wrote:Are you sure that they are spaces in the source data?

yes...

data is of type varchar(50) ex: in seqfile : "GATEWAY NEW BUSINESS 14.9" while viewing from unix : "GATEWAY NEW BUSINESS 14.9 (I used code mark so that the spaces display) What tool are you using to "view" the data? If you read the file in DataStage and output a LEN(In.Stri...

Hi, We are getting one space less in the middle of a string when viewing the data through seqfile, but the same data when viewd in unix is showing correct. data is of type varchar(50) ex: in seqfile : "GATEWAY NEW BUSINESSxx14.9" ( spaces are shown as x) while viewing from unix : "GAT...

Hi, i need help in implementing the below logic. If ((current date - open_date ) > 13 months) Then "Y" Else "N" here opendate is decimal(7,0) like MMDDYY format. help me in getting the current date in datastage and also to implement (result )> 13 months. Thanks Sultan hi i have ...

Hi,

i need help in implementing the below logic.

If ((current date - open_date ) > 13 months) Then "Y" Else "N"

here opendate is decimal(7,0) like MMDDYY format.

help me in getting the current date in datastage and also to implement (result )> 13 months.

Thanks
Sultan

hi
what is force compilation ,what will hapen if we force compile a job

can any one explain about this. thanks in advance

HI
When DS cleanup resource is used in director where it will stores the logs.Let me know if my quetion is not clear.

Thanks
Sultan

How many number of jobs can be run using a single sequencer job.

What do you mean by Real Time Integration in datastage? Is there any component especially available for doing this process?