DSXchange

ray.wurlod wrote:Use a sequence with an appropriate Execute Command activity to retrieve the file name and pass it to a Job activity as a parameter value. ...

Thank you

ray.wurlod wrote:A parallel job design is stored as (a) generated OSH, which can be viewed in job properties, and (b) generated C++ objects/libraries. ...

Thanks a lot....

Sainath.Srinivasan wrote:Your questions appear unconnected.

Are they for any interview ?

yes.....

How Connection Pooling can be done in DataStage?

*Title changed to be more descriptive - Content Editor*

How jobs internally implemented in Datastage Engine and I have to know in which format the jobs will be stored inside repository.

Please help

How to design a job that picks a file with today's date only from a folder and process some transformations...???

How to implement sorting on Server Job?

What are the properties need to be set inside Sort Stage

chulett wrote:Short answer is "yes" and quickest way to test would be to try it. ...

yes, I tried specifying the file name as

"sample.(19|20)\d\d[- /.](0[1-9]|1[012])[- /.](0[1-9]|[12][0-9]|3[01])"

but i cant able to view the data... Please help

Hi all In my source sequential stage properties I have specified Read method as File Pattern. Whether I can specify the file pathname with any regular expressions. For e.g., "X:\DS\sample.regular expression" My actual file name will be like this "sample.20090405" Please advice wi...

Thanks for ur response.... My format for file name is as follows eg MASS.F0XX.YYYY.200904051800. MASS- mandatory XX - it can be 0,1 or 2 like "F021" YYYY - the value will be from 0000 to 9999 200904051800- Timestamp should be in this format.. WHAT format ?!!! In a job sequence you might us...

yes .. first validating the filename with the format .. if it satisfies the format it should proceed further... Read it as a varchar and use constraints in transformer to separate out the header and trailer . You mentioned my file name for eg.MASS.F012.034.200904051800. each field should be validate...

Hi all

i have a requirement as when my job gets run the target file which i specified should return with the current system date.

for eg., i have to get the target file name as " sample 20090405.txt"

Pleas eadvice ... Thanks in advance...

Hi all Iam having a flat file which need to be processed.. The file is delimited by semicolon and before extraction the file name should be validated. my file name for eg.MASS.F012.034.200904051800. each field should be validated with some default format .. after the file naming pattern satisfies th...