DSXchange

Hi All, We are planning to Migrate from Windows V7.5 to Windows V9.1 and would appreciate any help with this process and estimation Landscape: 5 Projects 1000+ jobs 200+ Routines 100+ Batch jobs for Control Flow (No Sequence Stages used) 10+ Universe Basic Program called from Datastage Jobs mainly u...

It worked successfully by setting these properties

Record Delimiter String = \r
Final Delimiter = end

Thanks,
NV

Hi All, DS 8.7 on Windows 2008 R2 We have a Pipe delimited source File and the Record Delimeter is a Carriage Return.I am Using the Sequential File stage to read it. I tried using all the Record Delimiter options like end, none, whitespace , tab..but it fails and cannot read the file Then I tried us...

SURA,

What the other approach you took..can you explain how you achived this

I have similar issue.. The $APT_IMPORT_PATTERN_USES_FILESET = TRUE has been set in the job When I pass parameters like this in the File Pattern - #FileConnections.pSrcFilePath##FileConnections.pSrcFileName#*.TXT (Read Method = File Pattern) I get an error as below, even though the file is present Fi...

Yes MERGE is different and we need to terminate it with a semi colon But it is only failing when used in the Before SQL Statement with 2 Node Config file but not when used in a Before SQL (node) statement with a 1Node Config file. (In both cases the Semi Colin is provided at the end) From my underst...

Hi All, We r on DS 8.7 on Winddows 2008 R2 We are using a Row Generator stage to generate 1 Single record and then using the SQL Server MERGE statement to load data from Staging to Final table. This works fine when I use a 1-Node Configuraion and use this MERGE in the Before SQL (node) statement . B...

Hi All, DS 8.7 on Windows 2008 R2 We have successfully installed Operations Console and it runs fine. Currently in DEV. But we have noticed if we do not start it for a few days or we do not have any activity in Datastage (no job runs) ,on opening OC the "odbqueryapp" service shows status a...

So in a 2 Node Config RG executed Sequentially by Default will still generate 2 Rows even if the Number of Records = 1

1 * 2 = 2 ?

Hi All.
We are on DS 8.7 on Windows 2008 R2

If we use a Row Generator in a 2 Node Configuration setting and set the Number of Records =1, will it generate 1 record per partition (i.e total 2) or only 1 record on any 1 partition, sequential execution?

Thanks,
NV

Thanks All.

Hi All, DS 8.7 on Windows 2008 R2 I see for every Parallel job we built, these corresponding folders are created in the relavant Project directory on the server e.g. C:\IBM\InformationServer\Server\Projects\<Project_Name> RT_LOGxx -- Log associated with the job run RT_SCxx -- Source Code associated ...

Thanks for your reply BI-RMA. The dsadm was not set up during installation, only isadmin and wasadmin Can we set it up now? If yes, how can we do that Also Under Domain Management-->Engine Credentials-->Open Configurations we have this option, is there where we need to mention the dsadm user post cr...

Hi All, We are on Windows 2008 R2 for DS 8.7 (All 3 tiers, Services, Metadata and Engine are on same Server) For Security/User Authentication We are mapping credentials between the Information Server User Registry and the Datastage Engine (We are not using the Active Directory) My question is, as pe...

Hi All, DS 8.7 on Windows 2008 R2 Exterprise What are the Imp points to be considered before Re-Installation? We are currently in DEV phase and plan to back up the existing Project (and all relevant components) so we could import that back, post reinstallation. Do we have to Drop the XMeta DB (Metad...