DSXchange

Thx Chulett. Yes It is a Window machine over which FoxPro DB is hosted. You said "Is that directory mounted (NFS/Samba/whatever) on the ETL server?" What is 'NFS/Samba' is this a freeware ? Which all drivers i Will be required from ETL perspective ? We are able to read data .dbf file throu...

Hi,

I am having a requirement, where i need to connect to a FoxPro database hosted on a Microsoft directory.

User "infoadm" already given access over MS Dir.

Please suggest me steps to connect and access FoxPro DB through Datastage.

Regards.

Thx, it mean same. It worked.

Hi,

I am getting Double quotes in data.

Which Command to check for which records has Double quotes (") in it ?

Regards.

Hi All, I am having same requirement as noted here. I need to connect to FoxPro database through Datastage. Could any one please suggest me what all prerequisite i need to take care so that Datastage can successfully connect to FoxPro database. I know i need to make entry of DSN/connection to .odbc....

Hi,

If project server is working fine, I will suggest to split your Seq may be at least in 2 to 3 parts. Holding around 120+ stages on a single canvas is bit hard and you may land up with such problems.

Regards.

When ever data type char is defined then it will Pad spaces to existing data to make compatible with length of field.

So use Substring function to cut actual data characters form a space padded string.

You can write a server routine using following list of functions :- DSAttachJob, DSGetJobInfo, DSGetJobInfo, DSGetJobInfo, DSGetJobInfo It will help you in getting all required Datastage jobs auditing values and then you can write all parameters in some place holder using "Call DSExecute" ...

This is C++ Program for parallel routine :-- #include <iostream> #include <stdlib.h> #include <stdio.h> #include <string.h> char java (char* str1) { char i; i= system("sh java.sh str1 str1"); return i; } Please suggest me ... if i am missing any environmental variable need to be set to get...

Hi All I am getting following error when executing parallel routine :- "Xfmjava: Failed to load the library "V0S18_Load_Rec_MASS_ADJ_J_Xfmjava.o"; either the directory containing the library file is not on the library search path, or the library was compiled on a system that is incomp...

Hi,

I am also facing same issue. As suggested i have changed job name as well as stage name still it is not getting resolved can any one suggest over it.

Thanks Means it is not a part of Datastage Install pack ...

If we have javac compiler in Dev environment so we need to make sure that same need to be installed on Other server as well where this code will be migrated. Right ..??

Do "Javac" Compiler comes with Datastage ?? When were a Datastage engine is installed so dose automatically 'JavaC' compiler also get installed ? So that all java code can get executed. I have a requirement where i need to develop a datstage code which can handle Java coded files and we ne...

Thx. I am new to java stages ... Please share any tutorials how to use these all stages.

Even my last question is unanswered Can we execute ... Java code on Unix box or in Datastage through some routines directly or we need to install some addition patches.

Regards.

Thx for reply.

Just wanted to check .. do we need to install some patches on Datastage sever or on Unix box to execute Java Code ??