DSXchange

Can we use a compressed RAR file as source in Seqential stage,
If yes, how can i load the table defenitions,

Thanks in advance,

I tried this in Sequential Stage input page,

\\10.4.10.12\FileServer\mkr\Development_Projects\RMK\Final\Final_Query2.txt:

,but it throughs me an error of ,

Unable to open \\10.4.10.12\FileServer\mkr\Development_Projects\RMK\Final\Final_Query2.txt:
No such file or directory.

Thanks,

How to imply that in sequential stage
I am having the file in the Client machine,
How can call the Source TEXT file from the DS server

Thank you for your replies,

Hi ,
I have an rar file on another server. As it was a huge file of 3GB, i cant move it to the DS server, IS there any option in Datastage to fetch a file from another server. The File is in TXT format.

Please Suggest me a solution.
Thanks in Advance,

Specify the tab character in the Trim() function as the character to be trimmed. The tab character can be represented as Char(9). Performance tip: Evaluate Char(9) when initializing a stage vari ... I could not able to mention the Tab Char in the Trim function. Do i have to mention Char(9) for it? ...

I need to Trim the special Character "
" Tab Char.

I used Trim function ,but throughs me error!!!

Any Suggestions!

Thanks in Advance!

I wouldn't be quibbling if you were overriding their value. As noted, there's no reason to set any variable to its default value, especially an environment variable that will automatically get its value from the environment without any help from you. That's what they do. As you mean, there is no ne...

Can reset a job through DS Director!!

What are the permissions on RT_SCTEMP in your project? What permissions do you have to it? What permissions does dsapi_slave have to it? ... To be Open, I dont know! ,I am actually new to this phrases RT_SCTEMP ,dsapi_slave... Can you please explain the steps to be done for overcoming this! :? :? :?

The Parameters are called as User Defined Environment Variable!

You should not even be allowed to copy in production; production should ideally be a protected project. Use the Data Set Management Tool (or equivalent orchadmin commands) to view the record schema ... Sorry for the delay, I tried to use the Data Set management to view the data, But the following e...

Still... all this... completely unnecessary: ErrCode = DSSetParam(hJob1, "$DSDir", $DSDir) ErrCode = DSSetParam(hJob1, "$OracleUser", $Ora ...[/quote] Then how can we mention the Parameters and the defaults? Is there any other options for referring the Parameters in Job C ontrol...

Not including the Parameters in the Main job that calls all other Batch jobs ,is the ERROR that creates this problem.

Problem Solved!

Thank u for everyone!!

Why are you trying to 'set' a job parameter that's actually an environment variable? There's no need to do that as it will automatically pick it up from the... well... environment. ... I am using the following Code to call the batch jobs assciated with the main job, JobName1= "LOAD_TEST_TABLE&...

ArndW wrote:DataStage Server (which includes Job Sequences) does not allow the "$" sign as part of a variable name, which is why you are seeing the error. ...

Actually I am using the code in the DS Parallel Job Control to call all other Jobs