CODEWITHSUNDEEP
etldatastage
user2109468
user2109468

Reputation: 9

datastage parameter for file directory not working

I am creating an extract from sequential file. I created a parameter with the correct file location and when I try to "View Data", it says it can't find the file. If I hard code the location it finds the file and I am able to "View Data".

example:

#filedirectory# = aaa/bbb/ccc/

so my entry for "File" is #filedirectory#filename.txt and this does not work

however, the following does work aaa/bbb/ccc/filename.txt

Any ideas what would cause this?

Upvotes: 0

Views: 557

Answers (2)

maxx392
maxx392

Reputation: 11

I had the same issue, and it happened I forgot to include the directory parameter before the file parameter. Hope this information helps someone.

Upvotes: 0

MichaelTiefenbacher
MichaelTiefenbacher

Reputation: 4005

Try using the absolute path. Start with a / and the root directory.

Second point is that the parameter itself does not have "#". The "#" are only needed to reference it - in the Sequential File stage. So name it filedirectory when you define it in the job.

Recommendation: As filedirectory will probably be used throughout your project I recommand using a ParameteSet.

Upvotes: 0

Related Questions