DSXchange

The FTP stage in DataStage transfers data line-by-line using FTP calls; it doesn't use the classic FTP program as we are used to. Are you reading from or writing to the FTP stage? Are you specifying a valid userid and password (yes, I saw you mention "anonymous" ftp)? I'm writing to the F...

The FTP stage in DataStage transfers data line-by-line using FTP calls; it doesn't use the classic FTP program as we are used to. Are you reading from or writing to the FTP stage? Are you specifying a valid userid and password (yes, I saw you mention "anonymous" ftp)? I'm writing to the F...

Hello All, I'm having trouble using the FTP stage to connect to a FTP server. The server is local, unsercured and anonymous. I want to use the FTP stage to connect and send the data across. However, I get this error "socket call 'connect' failed". I'm presuming that the stage is using the ...

NeverMind. . I got that to work. It's clean enough. I have 3 jobs and 1 sequence. 1) The first job populates a Hashfile with ID and Filename returns the last @OUTROWNUMBER to the UserStatus. 2) The controller then loops through 1 to the last Job's UserStatus and returns the FileName to the UserStatu...

Hello All, I was just wondering if there is any known way of using a data field as a filename in a sequential stage. I was thinking, that I could maybe loop through the records and pull all the records into a table with an autonumber i.e. FileNamesTable ID,FileNameCode,FileName 1,BF,BobsFile 2,JDF,J...

I changed the format to unformatted in datastage and used MS Visual Studio to reformat it. Edit -> Advanced -> Format Document. Save. Worked wonders. IE is very slow rendering XML. And I needed it in a clean format quickly for me to see that what I was getting was correct. I found VS 2005 much faste...

Good Point ..

I was trying to format it for the human eye.

thanks for the input.

I couldn't find any posts regarding this issue of the XML format coming out of the XML output stage. The XML format I'm expecting is: <DEDUCTIONS> <DEDUCTION> <SURNAME>MCDONALD</SURNAME> <NAME>OLD</NAME> </DEDUCTION> <DEDUCTION> <SURNAME>MCDONALD</SURNAME> <NAME>NEW</NAME> </DEDUCTION> </DEDUCTIONS>...

YEEEAASS!!! It works. Okay here are my findings for all windows users. 1) You need to create 2 new System Environment Variables. 1. Name: DATASTAGE_JRE Value: C:\IBM\InformationServer\ASBNode\apps 2. Name: DATASTAGE_JVM Value: \jre\bin\j9vm 2) Restart your Server. (Very important, bugged me for hour...

Still No solution. I've tried all variations of the classpath and the path environment variables. Do i have to restart after each change? I don't think so, just checking. I've this and it just takes a very long time to test and it feels as if I'm grasping at straws. Is anyone else battling with this...

Can anyone help me on this problem.? I've a simple small webservice up and running. I've got the WSDL definitions in the WS Client and I'm trying to pass it 1 row of 4 columns of information. But I get this error. I'v found many posts on this error but none that fix my problem. PavlovCreateTask..Web...

Progress update .. I got rid of the RNIWrapper error. Just still this. I've tried all kinds of claspath's and also found classpath in the gridstyle properties of the client. Still get this error. Help!. Should I start a new Post? PavlovCreateTask..Web_Services_Client_0: TJClient::initialize: unable ...

I've tried all the CLASSPATH and System Variables suggestions and nothing has changed I still get the same message over and over. Can any one help here? PavlovCreateTask..Web_Services_Client_0: TJClient::initialize: unable to create Java Virtual Machine; classpath = C:\IBM\InformationServer\Server\D...

RK, Your job aborted becasue the DS couldn't find the "/jre/bin/classic" directory under the /etlinstall/IBM/InformationServer/Server/DSEngine/java, that's why you need to create a link (soft link), "jre -> /etlinstall/IBM/InformationServer/ASBNode/apps/jre", from the /etlinstal...

Ahha, thanks Craig.
the definitions were looking like this:
changed to look like this no more warnings.
Thanks