DSXchange

Through Information Server Manager (or its command line interface istool) you can check-in and check-out DataStage and other components. For non-IBM source code control systems this is managed throug ... Ray, May I know if the IS Manager ensures a checked out object is no more editable through the ...

ray.wurlod wrote:Is it possible to obtain the data in delimited format? ...

Yes. But that would be a change request to the source system and as well I need to convince them that this solution(fixed length file) would not work

ray.wurlod wrote:No single method - it depends on source. For example, Oracle uses a factor of 3 - you would specify VarChar(105). Try a factor of 2 first - that is, VarChar(70). ...

Thanks !

I have tried varcha(70),(140) and bigger values too.
Tried nvarchar and nchar too.

Any other options please?

Each character may occupy one, two, three or even four bytes. True fixed-width is almost always impossible (at least where the unit of measurement is "bytes"). Is it possible to obtain the data in d ... I am actually unable to read the premium content. But I am able to process the file if...

There is a customer_name field in the source .dat file received. This name is in Chinese sometimes. It's unicode length is 35. I have defined this field as varchar(35) with unicode set in a sequential file stage. NLS is set to UTF-8. I am able to read the chinese characters and load it into the DB2 ...

It throws the same error even when I use only current timestamp

Datastage is running on zLinux and DB2 on zOS. Connection between these two server is fine. Some of the Ds jobs are running fine. Some of them throw communication failure error in DS. The same shows the following error in the DB2 log. 07.13.41 STC07895 DSNL027I -DBP1 SERVER DISTRIBUTED AGENT WITH 75...

I am also getting the same error message.The issue persists even after restarting the client multiple times.

Any suggestions appreciated, please.

regards,
Murali

Thanks for all your replies!!! I definitely agree only if rejects are designed accordingly, we will be able to reconcile source,target and rejects. Our jobs are designed and tested fine in such a way that source is always an addition of target count and reject count. Now the issue is only with the g...

Hi, My requirement is to generate a report that gives the following details for each job that runs on the server. Number of rows read from source - a Number of rows inserted into target - b Number of rows rejected - c So in any case a = b+c This kind of reconciliation is a part of the process in our...

Hi , The requirement is to pass the Current timestamp value to the UPDATE_TIMESTAMP column, but to fetch its value from the DB2 server and not the DS server.So I have modified the update query as follows: UPDATE #TargetSchemaName#.ARREARS_LETTER_INFORMATION SET LAST_ARREARS_LETTER_TYPE=?,LAST_ARREAR...

Hi , I have many posts on similar topic ,but nothing worked for me ,as I have set all the configuration parameters right. /opt/IBM/InformationServer/Server/DSEngine/.odbc.ini [ODBC Data Sources] ARTSTDB=DataDirect DB2 Wire Protocol Driver for ARIW3 [ARTSTDB] Driver=/opt/IBM/InformationServer/Server/...

I have installed DS8 on zLinux machine.The Websphere Application Server was installed in the following path /opt/IBM/WebSphere/AppServer.I am able to login to the Web Console , but the name of my server is not getting listed in the console. The users and groups tab are fine...but when I go to creden...

I have found the solution . There were few ports that were blocked by firewall. Below listed ports need to be configured on firewall access when clients are on other side of firewall from server. 9080 16581 31538 9060 9043 2809 9100 9401 -- 9403 javascript:emoticon(':D') you must check for access f...

Gurus, This solution of x:col is gonna return a NULL value if the value of col is NULL. i have 3 cols to be concatenated say x,y,z. If isNull(x) then ' ' else x : If isNull(y) then ' ' else y : if isNull(z) then ' ' else z this condition does not return the value of z ,if the y becomes a NULL value....