Problems using File Pattern option with DataStage in Windows
Moderators: chulett, rschirm, roy
Problems using File Pattern option with DataStage in Windows
Hello all.
I got this situation in where I want to read two files with the same structure.
Test1.txt
Test2.txt
I'm using Job Parameters to define the fullpath.
In the Sequential File Stage in the File Pattern field I define the following:
#PathToFile#\Test*.txt
When I run the Parallel Job alone I got this errors.
CSV_PCP_IPA_MemberMonths_Read: Invalid filename specified: Invalid hostname: <hidden>.
If I change the Read Method of the Sequential File Stage to Specific File then define in the File box the following:
#PathToFile#\Test1.txt
Runs perfectly.
Any suggestion?
I got this situation in where I want to read two files with the same structure.
Test1.txt
Test2.txt
I'm using Job Parameters to define the fullpath.
In the Sequential File Stage in the File Pattern field I define the following:
#PathToFile#\Test*.txt
When I run the Parallel Job alone I got this errors.
CSV_PCP_IPA_MemberMonths_Read: Invalid filename specified: Invalid hostname: <hidden>.
If I change the Read Method of the Sequential File Stage to Specific File then define in the File box the following:
#PathToFile#\Test1.txt
Runs perfectly.
Any suggestion?
Re: Problems using File Pattern option with DataStage in Win
The problem is with the test file you created might be the reason is my guess . Try it again with another file having multiple columns.
Set proper delimiter
Use File pattern
DS User
Set proper delimiter
Use File pattern
DS User
Just for fun, try specifying the file path instead of a parameter and see what happens.
I've tried it using #PARAMNAME#test*.txt, where the PARAMNAME parameter is set as type pathname, and as a regular path, like D:\MyPath\ - works both ways.
Is it possible you've defined your #PATHTOFILE# parameter as string instead of as pathname, and that is causing your issue? Just a thought.
I've tried it using #PARAMNAME#test*.txt, where the PARAMNAME parameter is set as type pathname, and as a regular path, like D:\MyPath\ - works both ways.
Is it possible you've defined your #PATHTOFILE# parameter as string instead of as pathname, and that is causing your issue? Just a thought.
I don't have a sample that comes close to your situation, but I do have a question for our gurus: If the OS is Windows, does that mean that the DS runtime environment is running on a Windows server, or is it still on a Unix server?
That said, the times I've run into this sort of problem I've looked to the differences between Unix and DOS. Usually it's around the permitted characters. DOS allows spaces in directory and file names, Unix does not.
Good luck.
That said, the times I've run into this sort of problem I've looked to the differences between Unix and DOS. Usually it's around the permitted characters. DOS allows spaces in directory and file names, Unix does not.
Good luck.
Franklin Evans
"Shared pain is lessened, shared joy increased. Thus do we refute entropy." -- Spider Robinson
Using mainframe data FAQ: viewtopic.php?t=143596 Using CFF FAQ: viewtopic.php?t=157872
"Shared pain is lessened, shared joy increased. Thus do we refute entropy." -- Spider Robinson
Using mainframe data FAQ: viewtopic.php?t=143596 Using CFF FAQ: viewtopic.php?t=157872
If you are talking about the choice of OS you have when creating a new post then yes, if you say "Windows" it's supposed to mean you have the DataStage "engine" installed on a Windows server rather than a UNIX server.FranklinE wrote:I don't have a sample that comes close to your situation, but I do have a question for our gurus: If the OS is Windows, does that mean that the DS runtime environment is running on a Windows server, or is it still on a Unix server?
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers
Thanks, Craig. That means any advice I may offer here could be inaccurate. MarbinPR, please take note.
Franklin Evans
"Shared pain is lessened, shared joy increased. Thus do we refute entropy." -- Spider Robinson
Using mainframe data FAQ: viewtopic.php?t=143596 Using CFF FAQ: viewtopic.php?t=157872
"Shared pain is lessened, shared joy increased. Thus do we refute entropy." -- Spider Robinson
Using mainframe data FAQ: viewtopic.php?t=143596 Using CFF FAQ: viewtopic.php?t=157872