DSXchange

Does any body know the meaning of the following warining message:

FTP_Plug_in_0: %s

This message is from FTP Stage reading from Mainframe and transferring data to Server.

Thanks in advance

I am doing transferring files from Mainframe to server through FTP Stage of Server Edition. I found jobs aborted due to a Null Value for a 'Not Null' filed, but the acutual 'Not Null' field has a value. Error message: DBOBJftp..Transformer_1: Not enough columns (row 3), and column 'DB_OBJ_EDT' is no...

Hi Ray,

What is the best way I can do?

Is any easy way to do that?

Thanks in advanced

Billy

Hi Raig,

Yaeh, you can say it is a 'Range Lookup'. I am looking for any way instead of put everything together into DB, then use SQL.

Thanks

Hi Rob, Thanks for your response. The lookup is Hash file. If Key expression can use >= or <= then that should not be a problem. But you can not use unequl operator for joint the input column with reference column, here are FromSal and ToSal. I am searching another way to solve this kind of look up....

simple lookup is equal join for Primary input with look up keys. Is any way to lookup with non-equaljoint expression? For example: in primary input: EmpNo Salary 1001 4550.55 in Reference input Sal_level FromSal EndSal 1 1000.00 1999.99 2 2000.00 2999.99 3 3000.00 3999.99 4 4000.00 4999.99 ............

simple lookup is equal join for Primary input with look up keys. Is any way to lookup with non-equaljoint expression? For example: in primary input: EmpNo Salary 1001 4550.55 in Reference input Sal_level FromSal EndSal 1 1000.00 1999.99 2 2000.00 2999.99 3 3000.00 3999.99 4 4000.00 4999.99 ............

Your date format is not "D/E", but "DDMY[2,2,4]" @Date> Iconv(Ln_Histor_Data_In.FICHE_DEBUT_VALIDITE_CH, "D/E") And @Date < Iconv('Ln_Histor_Data_In.FICHE_FIN_VALIDITE_CH', "D/E") Try This: @Date> Iconv(Ln_Histor_Data_In.FICHE_DEBUT_VALIDITE_CH, "DDMY[2,2...

Thanks Ray. Basically this message means that something has occurred in Windows that means that the OLE client has lost track of its connection with its OLE server. Does this error have any relation to Windows? I mean that any reason from working on Windows may cause this happen. I am trying to outl...

I am just posting the bugs--errors occurs when using DS 6.x The error message: (40503) A call to an OLE server has failed, or a runtime error occurred within the OLE server itself. When to occur: any time during the development like: open a stage; compile a job, even any action doing on DS. What to ...

This post is for questioning the bugs in Version 7.x. Has anyone experienced the bugs using DS 7.x server edition? If so, please list anyone and the best practice to prevent it occur. I am going to update DS 6.x to DS 7.x. Before doing that, one task is to create a plan for how to effectively using ...

Is any way to connect to mainframe and download the table definitions using DataStage? I am current using DS server edition 6.0. There are lots of files from mainframe needed to download to Unix server. Instead of typing the all file definitions, I need to find a better way to download the files and...

I have met this error in AGGREGATOR Stage twice in different cases: First time I set the Sort Columns in Input Link and it ran OK. But Second time ran another loading (a little bit small file than first time), the error occurred again. After removed the Sort setting, it ran OK. The question is: The ...