DSXchange

chulett wrote:It is not available until the 7.5.x releases. ...

Please suggest me how to implement Loop in a sequence job in DS7.1

Hi We are using Datastage 7.1r1.
I did not find Start Lopp activity and End Loop activity in Sequence Job.

Please let me know whether the stage is available in DS7.1V

If not what is the alternate option.

Post your routine code. Plus I'd suggest you think about doing this 'post job' as in a Sequence job or possibly after job. It depends on exactly what you mean by 'display an error' if the processed row count is zero. The code in the routine is as follows: DSGetLinkInfo(DSJ.ME,StageName','linkname',...

Search for DSGetLinkInfo as a starting point. ... The flow of job is as follows: Source->Transformer1-->Transformer2-->Target Now i need to check if the target is empty or it has rows. if there's no data coming to the target flat file then it has to display the error message. I created the routine ...

You'll never have a row go into an output link which requires a constraint check if there's no input rows. Your method doesn't work. Use an after-stage routine call and write a routine that checks the link values using the API libraries. Can u please tell me how to do that. I dont have idea on API ...

Hi my target is a flat file. I have to check whether any rows have been populated to the atrget file or not. if there are no rows they I have to display an error message. So after loading the data into a temporary file before loading into the target, i used a transformer to check the no. of rows goi...

Does anyone have any information on what approach to follow to call a webservice from datastage version 7.1? i am aware that RTI is the answer to it but of what i know, RTI is supported only from version 7.5 I do not work on datastage so i have some basic queries. I have heard that you can call a ja...

its very strange. if I try to map the drive with my ID, it is saying 'network path not found'. But if I give the same path in Run window, its getting connected.

Please find the following: I gave ftp <servername> at the command prompt. Connected to <servername> 220 server_6 FTP server (EMC-SNAS: 7:45:33:2) ready. User: <username> 331 password required for <username>. Password: <I entered the password> 530 Login incorrect. Login failed. ftp>

Hi We are using the ftp stage to copy a flat file to a share drive. We gave the correct server name , our windows login ID/password. but when we run the job we are getting the following error. "Login to the FTP server failed, invalid password for user co10004" we are able to connect to the...

chulett wrote:What turns up if you put 'Failed to compile test harness' into the Search function here? More than likely, the answer to your question!

I did not find any posting similar to my problem. I don't understand what does the error mean. Pls help me

Hi We are using Datastage 7.1r1 in Windows. I have to remove comma froma string. I am not able to use Ereplace or Convert or any other similar function in the transformer. So I created a test routine in the manager. Routine definition: Ans=Ereplace(Arg1, " ","") It is compiling w...

... and you will need to Trim() the trailing quote character from the result generated by the Field() function in this case. :!: ... Hi The problem is Address field contains many spaces in between. I have a function called CHANGE() which I am using in a transformer to remove the spaces. But before ...

I am not able to run the job at all. And When I try to view data in the source ODBC stage, full address is not getting displayed for the address column as given in Query analyser.
I am loading the data into a sequential file(target) using a transformer.

Hi I am querying from SQL server database using the ODBC stage. The query is just selecting the columns from the source table. The columns are ID(integer) and Address(varchar9255)). I am able to run the query at backend. But when I run the job I am getting the following error. Test_Address..AX_STR_s...